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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
