Thread: Logging in postgres
Hi Folks I want to log all of the inserts and delete that occur in a postgres database. Whats the easiest way to do this? -- Cheers Tony _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
On Sat, 2002-01-26 at 13:30, Antony Stace wrote: > > Hi Folks > > I want to log all of the inserts and delete that occur in a postgres database. Whats the easiest way to do this? tweak your postgresql.conf Markus Bertheau
Thanks for the reply Markus. I have added 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? > tweak your postgresql.conf > > Markus Bertheau Cheers Tony _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
On Sat, 2002-01-26 at 16:12, Antony Stace wrote: > Thanks for the reply Markus. I have added > > 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 Markus Bertheau
> > > 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? Cheers Tony --------------------------------------------------------------------- _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
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
Antony Stace <s45652001@yahoo.com> writes:
> 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?
If you're not seeing any log output at all, then either:
1. Postgres is logging to postmaster's stderr but you've directed same
to /dev/null (or not where you are looking, anyway).
2. Postgres is logging to syslog, but you've configured syslog to
discard the output (or put it somewhere else than where you are
looking).
regards, tom lane