Thread: Database log

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

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