From: Dmitry Samersoff <dms@wplus.net>
To: pgsql-hackers@postgreSQL.org
Subject: Files ...
Date: Thu, 26 Aug 1999 20:43:14 +0400 (MSD)
Message-ID: <XFMail.990826204314.dms@wplus.net> (raw)
This is three files IMHO useful for community
1. SysV start script for postgres, also can be used under freebsd
(see below)
2. simple utility su_postgres, it make su to user postgres whether or not
shell for it specified, is better than su for security reason
3. configure/configure.in checking for ps style
BSD ps -ax or SysV ps -e
Probably, there is the reason to include it (after some improvement0 into
distribution.
---
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net
* There will come soft rains ...
============================================================================
#ident "@(#)/etc/init.d/pgsql 1.0 26/08/99 dms"
PG_HOME="/usr/local/pgsql"
PG_DATA="$PG_HOME/data"
UDS="/tmp/.s.PGSQL.5432"
PS="@PS@"
GREP="@GREP@"
case "$1" in
'start')
# If no postgres run, remove UDS and start postgres.
pid=
set -- `$PS | $GREP postmaster | $GREP -v grep`
[ $? -eq 0 ] && pid=$1
if [ -z "$pid" ]; then
rm -f "$UDS"
$PG_HOME/bin/su_postgres "$PG_HOME/bin/postmaster -D $PG_DATA
-b $PG_HOME/bin/postgres -i -S -o -F &"
echo "Postgres started"
else
echo "Postmaster already run with pid $pid"
fi
;;
'stop')
pid=
set -- `$PS | $GREP postmaster | $GREP -v grep`
[ $? -eq 0 ] && pid=$1
if [ -z "$pid" ]; then
echo "Postgres not run"
else
echo "Stoping postmaster with pid $pid"
kill $pid
fi
;;
*)
echo "USAGE: $0 {start | stop}"
;;
esac
Attachments:
[application/octet-stream] pg_run.tar.gz (9.2K, ../XFMail.990826204314.dms@wplus.net/2-pg_run.tar.gz)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: dms@wplus.net
Subject: Re: Files ...
In-Reply-To: <XFMail.990826204314.dms@wplus.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox