Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, June 01, 2009 1:59 PM
To: Kenny W Drobnack
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] rotating log files and adding timestamps to postgres logs
Kenny W Drobnack writes:
> I'm working with an application running on PostgreSQL 7.4.17
You were close, Tom. The option is
log_timestamp = true
in the postgresql.conf file. log_line_prefix is new as of version 8.0.
> but there are no timestamps in the file except for when
> the database was restarted. Any configuration option that can be
> changed to get timestamps in the lo
Kenny W Drobnack writes:
> I'm working with an application running on PostgreSQL 7.4.17 on RedHat
> Enterprise Linux.
You mean Red Hat's RHEL-4 packaging, or somebody else's?
> When asked to troubleshoot a problem, I found out
> the script that starts the PostgreSQL server
> (/etc/rc.d/init.d/po
I'm working with an application running on PostgreSQL 7.4.17 on RedHat
Enterprise Linux. When asked to troubleshoot a problem, I found out the script
that starts the PostgreSQL server (/etc/rc.d/init.d/postgresql) was logging to
/dev/null To try to fix this, I changed PGLOG=/dev/null to
PGLOG
