Trouble with query logging - Mailing list pgsql-general

From ppi@amug.org
Subject Trouble with query logging
Date
Msg-id 20040922035137.GX75691@wyeth.trail.calm
Whole thread Raw
Responses Re: Trouble with query logging
Re: Trouble with query logging
List pgsql-general
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!

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: difference 7.3.xx vs 7.4.xx
Next
From: Miles Keaton
Date:
Subject: brand new user - should I start with v8?