Обсуждение: postmaster logfile

On Dec 3, 2007 2:35 PM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
>
> What's a good way to start the postmaster, send the log info to a logfile
> somewhere, and return the linux prompt?

Use whatever startup script comes with the pacakge for your OS.  I.e.
in redhat or suse you should have a postgresql script that lives in
/etc/init.d/ that gets symlinked to the appropriate /etc/rc.d/rcx.d
directory.

> v8.2.0 on suse64

You should really be running at least 8.2.4, preferable 8.2.5.  8.2.0
has some nasty bugs.

Well, I can start the server with....

postmaster -D /myplace/db

... and then...
^z
bg

... to get to the prompt.  But each/every time a message from the
postmaster gets logged, it goes to stdout of the current window.  I want
it to go to a logfile.  Attempts to redirect with "&" all seem to fail.
"postmaster -d myplace/db -l logfile start" (as was in the message right
after the initial db create) doesn't seem to work.


I'll request v8.2.5.  Thanks for the advise.

-dave



-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Monday, December 03, 2007 4:13 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postmaster logfile

On Dec 3, 2007 2:35 PM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
>
> What's a good way to start the postmaster, send the log info to a
logfile
> somewhere, and return the linux prompt?

Use whatever startup script comes with the pacakge for your OS.  I.e.
in redhat or suse you should have a postgresql script that lives in
/etc/init.d/ that gets symlinked to the appropriate /etc/rc.d/rcx.d
directory.

> v8.2.0 on suse64

You should really be running at least 8.2.4, preferable 8.2.5.  8.2.0
has some nasty bugs.

Gauthier, Dave escribió:
> Well, I can start the server with....
>
> postmaster -D /myplace/db
>
> ... and then...
> ^z
> bg
>
> ... to get to the prompt.  But each/every time a message from the
> postmaster gets logged, it goes to stdout of the current window.  I want
> it to go to a logfile.  Attempts to redirect with "&" all seem to fail.
> "postmaster -d myplace/db -l logfile start" (as was in the message right
> after the initial db create) doesn't seem to work.

Enable the redirect_stderr config option in postgresql.conf.  That
should do the trick.  You can change the log file name and directory
on postgresql.conf too.

initdb doesn't say you can use -l in postmaster; it is talking about
pg_ctl.

--
Alvaro Herrera                 http://www.amazon.com/gp/registry/CTMLCN8V17R4
"MySQL is a toy compared to PostgreSQL."             (Randal L. Schwartz)
      (http://archives.postgresql.org/pgsql-general/2005-07/msg00517.php)