Logging the starting and stopping of PostgreSQL - Mailing list pgsql-admin

I have a script that starts PostgreSQL as a service.  It uses the following command to start the database:

$SU -l postgres -c "$PGENGINE/postmaster -p '$PGPORT' -D '$PGDATA' ${PGOPTS} &" >> "$PGLOG" 2>&1 < /dev/null

On my production server I use a slightly different command:

exec ${PGENGINE}/pg_ctl start  -D ${PGDATA}  -l ${PGLOG}

I noticed that the first command sends starting up info about PostgreSQL to the log file specified by $PGLOG; while the second startup command does not send anything to the log file.  What is the reason for this?  I also have the same issue with shutting down.

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu