Re: Logging in postgres - Mailing list pgsql-admin

From Markus Bertheau
Subject Re: Logging in postgres
Date
Msg-id 1012059778.1754.5.camel@saphir
Whole thread Raw
In response to Re: Logging in postgres  (Antony Stace <s45652001@yahoo.com>)
List pgsql-admin
On Sat, 2002-01-26 at 16:51, Antony Stace wrote:
>
> >
> > > log_connections = yes
> > > log_timestamp = true
> > > log_pid = true
> > > syslog = 2
> > >
> > > to my postgresql.conf file but it dosent seem to have caused any logging to occur in
> > >
> > > /var/log/postgresql
> > >
> > > Anything else I need to do?
> >
> > add
> >
> > debug_print_query = true
> >
> I just added
>
> debug_print_query
>
> restarted postgres and then did a few queries in the database.  But nothing
> is being logged in /var/log/postgresql.  Any ideas what else might be wrong?

hmm, that is my postgresql.conf:

tcpip_socket = true
port = 5432
hostname_lookup = false
sort_mem = 128
shared_buffers = 12288 # min 16
fsync = off
deadlock_timeout = 10000
wal_buffers = 64 # min 4
wal_files = 4 # range 0-64
log_connections = true
log_timestamp = true
log_pid = true
debug_print_query = true
debug_print_rewritten = false
show_executor_stats = false
show_query_stats = false

what is different?

btw: I presume we talk about 7.1.x

Markus Bertheau


pgsql-admin by date:

Previous
From: Chris Ruprecht
Date:
Subject: Re: Increasing Shared Memory - on MacOS X
Next
From: "Nick Fankhauser"
Date:
Subject: Re: Increasing Shared Memory - on MacOS X