Kenny W Drobnack <kenny.w.drobnack@jpmchase.com> 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/postgresql) was logging to /dev/null
Yeah, not the best solution :-(. Later versions of that script do better.
> To try to fix this, I changed PGLOG=/dev/null to
> PGLOG="| /usr/sbin/rotatelogs /var/log/pgsql 86400"
That's not going to work in any shell I know about. You'd have to
actually tweak the script a bit, along the lines of
$SU -l postgres -c "$PGENGINE/postmaster -p ${PGPORT} -D '${PGDATA}' ${PGOPTS} &" >> $PGLOG 2>&1 < /dev/null
becomes
$SU -l postgres -c "$PGENGINE/postmaster -p ${PGPORT} -D '${PGDATA}' ${PGOPTS} &" 2>&1 < /dev/null |
/usr/sbin/rotatelogs/var/log/pgsql 86400
> On a related note, I'm currently just doing "PGLOG=/var/log/pgsql".
> It is working, 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 log file?
Look at log_line_prefix (I think 7.4 had that, though it's a long time
ago...)
regards, tom lane
