| 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: | Whole Thread | Raw Message | 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
| 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 |