postgresql/postgresql-init

#!/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: $network $remote_fs
# Default-Start:  3 5
# Default-Stop:   
# Description:    Start the PostgreSQL master daemon
### END INIT INFO

# Source SuSE config
PG_SYSCONFIG=/etc/sysconfig/postgresql
test -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.status

eval DATADIR=${POSTGRES_DATADIR:-~postgres/data}
OPTIONS=${POSTGRES_OPTIONS}
H=/usr/bin/postmaster
test -x $H || exit 5
PIDFILE=$DATADIR/postmaster.pid

if [ -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
    fi
fi

# 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)
	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\" $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.* $PIDFILE
	}

	## Start daemon with startproc(8). If this fails
	## the echo return value is set appropriate.
	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