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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
