Use syslog... It's documented on the website and in the
manual... Assuming you are running on Linux then adding/editing:
syslog = 1 # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
to $PGDATA/postgresql.conf and:
local0.* /var/log/postgresql
to /etc/syslog.conf and then doing:
/etc/init.d/syslog restart
/etc/init.d/postgresql restart
should give you the log you're looking for at:
/var/log/postgresql
I'll leave it to you to translate this to your flavour of UNIX (or
Linux)...
Lee.
Florian Litot writes:
> yes it's good but can i have the date with each line?
> At 10:14 08/11/02, Shridhar Daithankar wrote:
> >On 8 Nov 2002 at 9:42, Florian Litot wrote:
> > > What is the command to launch a trace
> > > i try postmaster -i -D .... -d 10 >logfile
> > > but the file is create but nothing are in why?
> >Try postmaster -i -D .... -d 10 >logfile 2>&1