Re: Logging in postgres

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