Jie Liang wrote: > I did, it didn't work. > > Jie Liang Works for me. Did you change postgresql.conf? Here's what mine looks like.
# # Syslog # # requires ENABLE_SYSLOG syslog = 1 # range 0-2 syslog_facility = 'LOCAL0' syslog_ident = 'postgres' From the online docs: SYSLOG (integer) PostgreSQL allows the use of syslog for logging. If this option is set to 1, messages go both to syslog and the standard output. A setting of 2 sends output only to syslog. (Some messages will still go to the standard output/error.) The default is 0, which means syslog is off. This option must be set at server start. To use syslog, the build of PostgreSQL must be configured with the --enable-syslog option. See: http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-config.html Joe ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster