Re: shuttting down postmaster - Mailing list pgsql-novice

(another try to bring my 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




Am Die, 04 Jul 2000 schrieben Sie:
> 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