Logging the starting and stopping of PostgreSQL

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Logging the starting and stopping of PostgreSQL
Date: 2007-08-23 19:17:17
Message-ID: B10E6810AC2A2F4EA7550D072CDE8760197D31@SAB-FENWICK.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Campbell, Lance 2007-08-23 19:38:08 Re: Installing Postgres
Previous Message Tena Sakai 2007-08-23 19:11:40 Re: tar, but not gnu tar