Fwd: Re: shuttting down postmaster - Mailing list pgsql-novice

(just a try to answer to the mailing-list)
Try kill -TERM <pid> instead of  kill -HUP <pid> or  kill-9 <pid>
If you have a shellscript that starts postmaster then you may start and stop
the postmaster.
I have one from SuSE-Linux :
(may be you have to configure for your system)
It is placed in /sbin/init.d/
Invoked during startup and shutdown
(You know the startup procedure in dependence of the runlevel ?)

[ how do you post to the mailinglist ?
I only get the postings but my answers don't appear ]
Christoph
#! /bin/sh
# Copyright (c) 1998 S.u.S.E. GmbH Fuerth, Germany.
#
# Author:
#         Karl Eichwalder <ke@suse.de>, 1998
#
# /sbin/init.d/postgres
#
#   and symbolic its link
#
# /sbin/rcpostgres
#

H=/usr/local/pgsql/bin/postmaster
# H=/sda4/usr/local/pgsql/bin/postmaster
 LOGFILE=/var/log/postgresql.log
DATADIR=/usr/local/pgsql/data
.. /etc/rc.config

# Determine the base and follow a runlevel link name.
base=${0##*/}
link=${base#*[SK][0-9][0-9]}

# Force execution if not called by a runlevel directory.
test $link = $base && START_POSTGRES=yes
test "$START_POSTGRES" = yes || exit 0

# The echo return value for success (defined in /etc/rc.config).
return=$rc_done
case "$1" in
    start)
    echo -n "Starting service postgres"
    ## Start daemon with startproc(8). If this fails
    ## the echo return value is set appropriate.

        su - postgres -c "/sbin/startproc -l $LOGFILE $H -i -o -F -D$DATADIR"\             || return=$rc_failed
        echo -e "$return"
        ;;
    stop)
    echo -n "Shutting down service postgres"
    ## Stop daemon with killproc(8) and if this fails
    ## set echo the echo return value.

    killproc -TERM $H || return=$rc_failed

    echo -e "$return"
    ;;
    restart)
    ## If first returns OK call the second, if first or
    ## second command fails, set echo return value.
    $0 stop  &&  $0 start  ||  return=$rc_failed
    ;;
    reload)
    ## Choose ONE of the following two cases:

    ## First possibility: A few services accepts a signal
    ## to reread the (changed) configuration.

    #echo -n "Reload service postgres"
    #killproc -HUP /usr/sbin/postgres || return=$rc_failed
    #echo -e "$return"

    ## Exclusive possibility: Some services must be stopped
    ## and started to force a new load of the configuration.

    $0 stop  &&  $0 start  ||  return=$rc_failed
    ;;
    status)
    echo -n "Checking for service postgres: "
    ## Check status with checkproc(8), if process is running
    ## checkproc will return with exit status 0.

    checkproc $H && echo OK || echo No process
    ;;
#     probe)
#         ## Optional: Probe for the necessity of a reload,
#         ## give out the argument which is required for a reload.
#
#         #test /etc/postgres.conf -nt /var/run/postgres.pid && echo reload
#         ;;
    *)
#    echo "Usage: $0 {start|stop|status|restart|reload[|probe]}"
    echo "Usage: $0 {start|stop|status|restart|reload}"
    exit 1
    ;;
esac

# Inform the caller not only verbosely and set an exit status.
test "$return" = "$rc_done" || exit 1
exit 0



> How can I shut down the postmaster? Everytime I reboot my pc I have
> problems to re-start it. There's always a file indicating that postgres is
> running, althoug it is not. This is created everytime I run postmaster. I
> must have a way to have postmaster deleting this file everytime it is shut
> down.
>
>     Paulo