Trouble with query logging
| От | ppi@amug.org |
|---|---|
| Тема | Trouble with query logging |
| Дата | |
| Msg-id | 20040922035137.GX75691@wyeth.trail.calm обсуждение |
| Ответы |
Re: Trouble with query logging
Re: Trouble with query logging |
| Список | 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 по дате отправления: