Re: Loggin SQL Statements from JBOSS/JDBC - Mailing list pgsql-general

On Friday 14 November 2003 17:08, Thomas LeBlanc wrote:
> Where are the log files written?

Usually somewhere in /var/log/ but it depends on your startup script. If
you're on RedHat Linux and using the RPMs then your startup script is
/etc/init.d/postgresql and it seems to redirect to /dev/null (around line
157).

Personally, I like to log via syslog. In your postgresql.conf set:
syslog = 2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'

In /etc/syslog.conf add:
# Postgresql logfile
local0.*                        /var/log/postgresql

touch /var/log/postgresql

Add /var/log/postgresql to /etc/logrotate.d/syslog so you logs get recyled and
then:
service syslog restart
service postgresql restart

These are for RedHat Linux, but the process will be similar on most unix-like
systems.
--
  Richard Huxton
  Archonet Ltd