Scripts used to start/stop/check postgresql. (2010)

check_postgresql.sh

#!/bin/sh

PidFile=/usr/local/pgsql/data/postmaster.pid

foo()
{
  if [ -f "$PidFile" ]; then
    pgrep postgres | grep `head -1 $PidFile`
  fi
}

Pid=`foo`
if [ -z "$Pid" ]; then
  echo "postgres is stopped."
else
  echo "postgres ($Pid) is running."
fi

start_postgresql.sh

#!/bin/sh

su -c '/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data -k /var/run/postgresql >/usr/local/pgsql/var/log/postgres.log 2>&1 &' postgres

stop_postgresql.sh

#!/bin/sh

kill -INT `head -1 /usr/local/pgsql/data/postmaster.pid`