Database log

Jean-Christophe Pazzaglia writes:

we tried to switch the log on by lauching the postmaster
with -d 5 redirected to a file but this file is deseperatly empty,
what it's wrong ? is the process writing to an other file or
do we made a mistake with the arguments ?

Don't use the -S option.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

Jean-Christophe Pazzaglia <jc.pazzaglia@albourne.com> writes:

we tried to switch the log on by lauching the postmaster
with -d 5 redirected to a file but this file is deseperatly empty,

If you're using -S, stop doing so ...

regards, tom lane

try using the pg_options file itself, which, if you compile --with-syslog
support, will allow you to write to syslog. the main benefit being, you
can rotate your log files, which you can't if you do a redirect to a file

On Fri, 29 Sep 2000, Jean-Christophe Pazzaglia wrote:

Hi,

we tried to switch the log on by lauching the postmaster
with -d 5 redirected to a file but this file is deseperatly empty,
what it's wrong ? is the process writing to an other file or
do we made a mistake with the arguments ?

thanks in advance

regards,

jc

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org