Postgres/Postmaster logging and log rotation

Поиск
Список
Период
Сортировка
От William L James
Тема Postgres/Postmaster logging and log rotation
Дата
Msg-id 3AA64F95.F9323A84@inetmi.com
обсуждение исходный текст
Ответы Re: Postgres/Postmaster logging and log rotation  (Peter Eisentraut <peter_e@gmx.net>)
Re: Postgres/Postmaster logging and log rotation  (root <root@dennis.veritime.com>)
Список 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@inetmi.com
WWW: http://www.inetmi.com



В списке pgsql-admin по дате отправления:

Предыдущее
От: tolik@aaanet.ru (Anatoly K. Lasareff)
Дата:
Сообщение: Re: cannot create new user in postgres
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Postgres/Postmaster logging and log rotation