Re: [GENERAL] Problem getting sql statement logging to work

2005-01-24 Thread David Klugmann
Michael Many thanks. Configuring the syslog.conf and using logger to check it was working did the trick. Previously I had no local0 entries in the syslog.conf which was my problem. David From: Michael Fuhr <[EMAIL PROTECTED]> To: David Klugmann <[EMAIL PROTECTED]> CC: p

Re: [GENERAL] Problem getting sql statement logging to work

2005-01-18 Thread David Klugmann
Many thanks for the help Michael I did restart the postmaster a few times. I will give the other suggestions a go and let you know what happens. David From: Michael Fuhr <[EMAIL PROTECTED]> To: David Klugmann <[EMAIL PROTECTED]> CC: pgsql-general@postgresql.org Subject: Re: [GENE

[GENERAL] Problem getting sql statement logging to work

2005-01-18 Thread David Klugmann
article on the web which suggested setting debug_print_query = on. Is this an alternative way of setting logging ? Thanks for any help. David Klugmann # - Syslog - syslog = 2 # range 0-2; 0=stdout; 1=both; 2=syslog syslog_facility = 'LOCAL0' syslog_ident = '