Thread: Database log

Database log

From
Jean-Christophe Pazzaglia
Date:

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
Attachment

Re: Database log

From
Peter Eisentraut
Date:
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/



Re: Database log

From
Tom Lane
Date:
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


Re: Database log

From
The Hermit Hacker
Date:
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