Re: rotatelog / logrotate with PostgreSQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: rotatelog / logrotate with PostgreSQL
Дата
Msg-id 21892.1032794155@sss.pgh.pa.us
обсуждение исходный текст
Ответ на rotatelog / logrotate with PostgreSQL  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Ответы Re: rotatelog / logrotate with PostgreSQL  (Roland Roberts <roland@astrofoto.org>)
Список pgsql-general
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> Can someone send an example of how they have the
> logrotate / rotatelog script working with PostgreSQL?

Should work to just pipe the postmaster's stderr into it, eg

    postmaster ... 2>&1 | logrotate ...  &

> Also, is there an easy way to tell if PostgreSQL have
> been configured with "--enable-syslog"?

I think pg_config would tell you, but the most reliable way is to try to
set the postgresql.conf setting and see if the postmaster will take
it...

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] Monitoring a Query
Следующее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: Getting acces to MVCC version number