pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chander Ganesan <chander@otg-nc.com>
To: Campbell, Lance <lance@uiuc.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Logging the starting and stopping of PostgreSQL
Date: Thu, 23 Aug 2007 17:59:44 -0400
Message-ID: <46CE0350.20604@otg-nc.com> (raw)
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760197D31@SAB-FENWICK.sab.uiuc.edu>
References: <B10E6810AC2A2F4EA7550D072CDE8760197D31@SAB-FENWICK.sab.uiuc.edu>

Campbell, Lance wrote:
>
> 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
>
You do know that there is a pre-built startup script in the 
contrib/start-scripts directory?   You might try using that rather than 
reinventing the wheel in a variety of ways...
>
>  
>
> 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.
>
It looks like in your first startup script you redirect the output so 
the startup script is created by the user "root" (and hence owned by 
root).  In the second one, you start as postgres (or whomever your 
server runs as), and as a result the log file would have to be owned by 
that user as well.  Is it?  I'm assuming that (by your text above) that 
the file already exists but no new output appears there - this may be 
because the file is owned by the root user.  You should probably change 
the ownership of the file so that the postgresql user can write to it.

hope that helps.

-- 
Chander Ganesan
The Open Technology Group
One Copley Parkway, Suite 210
Morrisville, NC  27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com
Expert PostgreSQL Training

view thread (3+ messages)  latest in thread

Message-ID: <46CE0350.20604@otg-nc.com>
Permalink:  ../46CE0350.20604@otg-nc.com/
Also on:    postgresql.org/message-id/46CE0350.20604@otg-nc.com

 · 

reply

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-admin@postgresql.org
  Cc: chander@otg-nc.com, lance@uiuc.edu
  Subject: Re: Logging the starting and stopping of PostgreSQL
  In-Reply-To: <46CE0350.20604@otg-nc.com>

* 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