Search Postgresql Archives

Re: Problem getting sql statement logging to work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <mike@xxxxxxxx>
To: David Klugmann <dklugmann@xxxxxxxxxxx>
CC: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  Problem getting sql statement logging to work
Date: Tue, 18 Jan 2005 09:51:27 -0700

On Tue, Jan 18, 2005 at 03:05:34PM +0000, David Klugmann wrote:
>
> I have the following entries in my postgresql.conf file yet it doesn't seem
> to log anything.


Did you restart the backend after modifying postgresql.conf?

> syslog_facility = 'LOCAL0'

Have you configured /etc/syslog.conf to send local0 messages anywhere?
You might need to add an appropriate line to /etc/syslog.conf, touch
the desired log file if it doesn't already exist, and send a HUP
signal to syslogd.

You can test your syslog configuration with the "logger" program.
I think log_statement sends messages to the LOG_INFO syslog level,
so run the following command from the shell prompt and see if the
message gets logged:

logger -p local0.info "test 1 to local0.info"

Verify that your syslog configuration is working, make sure you've
restarted the PostgreSQL backend so it knows about the configuration
changes, and try again.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/



---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux