#!/bin/sh# Copyright (c) 1995-2004 SUSE Linux AG, Nuernberg, Germany.# All rights reserved.## Author: Kurt Garloff# Please send feedback to http://www.suse.de/feedback/## /etc/init.d/postgresql# and its symbolic link# /(usr/)sbin/rcpostgresql## This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.## System startup script for PostgreSQL## LSB compatible service control script; see http://www.linuxbase.org/spec/#### BEGIN INIT INFO# Provides: postgresql# Required-Start: $network $remote_fs# Required-Stop:# Default-Start: 3 5# Default-Stop: # Description: Start the PostgreSQL master daemon### END INIT INFO# Source SuSE configPG_SYSCONFIG=/etc/sysconfig/postgresqltest -f $PG_SYSCONFIG && . $PG_SYSCONFIG# Shell functions sourced from /etc/rc.status:# rc_check check and set local and overall rc status# rc_status check and set local and overall rc status# rc_status -v ditto but be verbose in local rc status# rc_status -v -r ditto and clear the local rc status# rc_failed set local and overall rc status to failed# rc_reset clear local rc status (overall remains)# rc_exit exit appropriate to overall rc status. /etc/rc.statusLOGFILE=/var/log/postgresqleval DATADIR=${POSTGRES_DATADIR:-~postgres/data}OPTIONS=${POSTGRES_OPTIONS}H=/usr/bin/postmastertest -x $H || exit 5PIDFILE=/var/lib/pgsql/data/postmaster.pidif [ -r $DATADIR/PG_VERSION ] ; then BIN_VERSION=$($H --version|sed 's/.* \([0-9]\+\.[0-9]\+\).*/\1/') DATA_VERSION=$(cat $DATADIR/PG_VERSION) if [ "$BIN_VERSION" != "$DATA_VERSION" ]; then for libdir in /usr/lib64 /usr/lib; do H=$libdir/postgresql/backup/$DATA_VERSION/postmaster test -x $H && break done if test -x $H; then export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$libdir/postgresql/backup" echo " Your databases are still using the format of PostgreSQL $DATA_VERSION." echo " Therefore a backup of the old PostgreSQL server program will be used" echo " until you have saved and removed your old database files" echo " See also /usr/share/doc/packages/postgresql/README.SuSE.{de,en} ." else echo " Your databases are still using the format of PostgreSQL $DATA_VERSION," echo " but no backup of the old PostgreSQL server program was found." echo " See /usr/share/doc/packages/postgresql/README.SuSE.{en,de}" echo " for details on updating PostgeSQL." exit 5 fi fifi# The echo return value for success (defined in /etc/rc.config).rc_reset# Return values acc. to LSB for all commands but status:# 0 - success# 1 - generic or unspecified error# 2 - invalid or excess argument(s)# 3 - unimplemented feature (e.g. "reload")# 4 - insufficient privilege# 5 - program is not installed# 6 - program is not configured# 7 - program is not running# # Note that starting an already running service, stopping# or restarting a not-running service as well as the restart# with force-reload (in case signalling is not supported) are# considered a success.pg_ctl () { CMD="/usr/bin/pg_ctl $@" su - postgres -c "LD_LIBRARY_PATH=$LD_LIBRARY_PATH $CMD"}case "$1" in start) touch $LOGFILE chown postgres:postgres $LOGFILE chmod 0600 $LOGFILE if [ ! -f $DATADIR/PG_VERSION ]; then echo -n "Initializing the PostgreSQL database at location ${DATADIR}" LANG_SYSCONFIG=/etc/sysconfig/language test -f "$LANG_SYSCONFIG" && . $LANG_SYSCONFIG LANG=${POSTGRES_LANG:-$RC_LANG} INITDB=/usr/bin/initdb install -d -o postgres -g postgres -m 700 ${DATADIR} && su - postgres -c \ "$INITDB --locale=$LANG --auth=\"ident sameuser\" $DATADIR &> initlog" || rc_failed rc_status -v rc_status || { echo "You can find a log of the initialisation in ~postgres/initlog ." rc_exit } fi echo -n "Starting PostgreSQL" ## remove old socket, if it exists and no daemon is running. checkproc -p $PIDFILE $H || { rm -f /tmp/.s.PGSQL.5432 $PIDFILE } ## Start daemon with startproc(8). If this fails ## the echo return value is set appropriate. #/sbin/startproc -e -t 1 -u postgres -l $LOGFILE $H $OPTIONS -D$DATADIR pg_ctl start -s -w -p $H -D $DATADIR -o "\"$OPTIONS\"" rc_status -v ;; stop) echo -n "Shutting down PostgreSQL" ## Stop daemon with killproc(8) and if this fails ## set the echo return value. pg_ctl stop -s -D $DATADIR -m fast rc_status -v ;; try-restart) ## Stop the service and if this succeeds (i.e. the ## service was running before), start it again. ## Note: try-restart is not (yet) part of LSB (as of 0.7.5) $0 status && $0 restart ;; restart) ## Stop the service and regardless of whether it was ## running or not, start it again. $0 stop $0 start rc_status ;; force-reload | reload) echo -n "Reloading configuration for PostgreSQL" pg_ctl reload -s -D $DATADIR rc_status -v ;; status) echo -n "Checking for PostgreSQL: " ## Check status with checkproc(8), if process is running ## checkproc will return with exit status 0. # Status has a slightly different for the status command: # 0 - service running # 1 - service dead, but /var/run/ pid file exists # 2 - service dead, but /var/lock/ lock file exists # 3 - service not running # NOTE: checkproc returns LSB compliant status values. checkproc -p $PIDFILE $H rc_status -v ;; probe) rc_failed 3 rc_status -v ;; *) echo "Usage: $0 {start|stop|status|try-restart|restart|force-reload|reload|probe}" exit 1 ;;esac# Inform the caller not only verbosely and set an exit status.rc_exit