postgresql.init

   1 #!/bin/sh
   2 #
   3 # postgresql    This is the init script for starting up the PostgreSQL
   4 #               server
   5 #
   6 # chkconfig:    345 85 15
   7 #
   8 # description:  Starts and stops the PostgreSQL backend daemon that handles \
   9 #               all database requests.
  10 #
  11 # processname:  postmaster
  12 # pidfile:      /var/run/postmaster.pid
  13
  14 # Source function library
  15 . /etc/rc.d/init.d/functions
  16
  17 # Get network config
  18 . /etc/sysconfig/network
  19
  20 # Get service config
  21 if [ -f /etc/sysconfig/postgresql ] ; then
  22         . /etc/sysconfig/postgresql
  23 else
  24         ALLOW_TCP_CONNECTIONS=no
  25         POSTGRES_DATA_DIR=/var/lib/psql
  26         POSTGRES_LOG=/var/log/pgsql
  27 fi
  28
  29 # Check that networking is up.
  30 if is_no "${NETWORKING}"; then
  31         msg_Network_Down Postgresql
  32         exit 1
  33 fi
  34
  35 # See how we were called.
  36 case "$1" in
  37   start)
  38         # Check if the service is already running?
  39         if [ -f /var/lock/subsys/postgresql ]; then
  40                 msg_Already_Running PostgreSQL
  41         else
  42                 # Sanity check
  43                 [ -f /tmp/.s.PGSQL.5432 ] || rm -f /tmp/.s.PGSQL.5432
  44
  45                 # Check for the PGDATA structure
  46                 if [ -f $POSTGRES_DATA_DIR/PG_VERSION ] && [ -d $POSTGRES_DATA_DIR/base/template1 ]; then
  47                     # Check version of existing PGDATA
  48                     if [ `cat $POSTGRES_DATA_DIR/PG_VERSION` != '7.0' ]; then
  49                         show "Databases created under incompatibile version. Migrate them first."; fail
  50                         exit 1
  51                     fi
  52                 else
  53                     # Create sample database
  54                     if [ ! -d $POSTGRES_DATA_DIR ]; then
  55                         mkdir -p $POSTGRES_DATA_DIR
  56                         chown postgres.postgres $POSTGRES_DATA_DIR
  57                     fi
  58                     su postgres -c "LD_LIBRARY_PATH=/usr/lib \
  59                         initdb --pgdata=$POSTGRES_DATA_DIR \
  60                         --pglib=/usr/lib/pgsql"
  61                 fi
  62
  63                 msg_starting PostgreSQL
  64                 busy
  65                 PGSQL_CMDLINE="$([ "$ALLOW_TCP_CONNECTIONS" = yes ] && echo "-i") \
  66                     $([ -n "$MAX_NUM_BACKENDS" ] && echo "-N $MAX_NUM_BACKENDS") \
  67                     $([ -n "$POSTGRES_DATA_DIR" ] && echo "-D $POSTGRES_DATA_DIR") \
  68                     $([ "$POSTGRES_QUIET". = yes. ] && echo '-o -Q') \
  69                     $([ "$POSTGRES_DIABLE_FSYNC". = yes. ] && echo '-o -F')";
  70                 su postgres -c "/usr/bin/postmaster $PGSQL_CMDLINE >>$POSTGRES_LOG 2>&1 &"
  71                 out=`status postmaster`
  72                 if [ $? -eq 0 ]; then
  73                     deltext; ok
  74                 else
  75                     deltext; fail
  76                     exit 1
  77                 fi
  78         fi
  79         touch /var/lock/subsys/postgresql
  80         ;;
  81   stop)
  82         if [ ! -f /var/lock/subsys/postgresql ]; then
  83                 msg_Not_Running PostgreSQL
  84                 exit 0
  85         fi
  86         msg_stopping postgreSQL
  87         killproc postmaster
  88         out=`status postmaster`
  89         if [ $? -eq 0 ]; then
  90             deltext; fail
  91             echo -e "\n$out";
  92             exit 1
  93         fi
  94
  95         rm -f /var/run/postmaster.pid
  96         rm -f /var/lock/subsys/postgresql
  97         ;;
  98   status)
  99         status postmaster
 100         ;;
 101   restart|reload)
 102         $0 stop
 103         $0 start
 104         ;;
 105   *)
 106         msg_Usage "$0 {start|stop|status|restart|reload}"
 107         exit 1
 108 esac
 109
 110 exit 0