Postgres/Postmaster logging and log rotation

From: William L James <BJames(at)inetmi(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres/Postmaster logging and log rotation
Date: 2001-03-07 15:11:17
Message-ID: 3AA64F95.F9323A84@inetmi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi there:

We are running PostgreSQL 7.0.2 on RedHat Linux 6.2 and
have encountered a few strange problems that continue to
elude us - namely INSERT and DELETE functions that end
abnormally, but do not include any information as to why (the
JDBC connection just seems to have gone away). Trying to
further diagnose the situation, I have been successful in starting
the Postgres logging (by including the following in the postgresql
script - su -l postgresql -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster start >>/var/log/postgresql 2>&1"), but
when the weekly logrotate.d function kicks in, Postgres logging
stops. We also have trouble doing a simple restart - I wind up
having to do a stop and then a start minutes later. Can anyone
explain how to get Postgres to log and to be able to rotate the
log periodically? Any information would be appreciated.

Thanks,
Bill James
I/NET, Inc.
Email: mailto:bjames(at)inetmi(dot)com
WWW: http://www.inetmi.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message root 2001-03-07 15:37:30 Re: Postgres/Postmaster logging and log rotation
Previous Message Silky Mittal 2001-03-07 09:33:52 Computer with Linux OS not shown on Computers with Windows OS