I'm having difficulty getting postgresql to log queries.
I have the following set in my postgresql.conf:
-------------------------------
# - Syslog -
syslog = 2 # range 0-2; 0=stdout; 1=both; 2=syslog
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
log_statement = yes
-------------------------------
I've done a:
pg_ctl reload -D /usr/local/pgsql/data/
and have even done a restart, but queries are not getting logged (to
/var/log/messages).
(Error messages are getting logged, however.)
I also tried specifying a log file using -l when doing pg_ctl restart.
Using postgresql version 7.4.
Any suggestions much appreciated!