Re: rotatelog / logrotate with PostgreSQL - Mailing list pgsql-general

From Tom Lane
Subject Re: rotatelog / logrotate with PostgreSQL
Date
Msg-id 7067.1032890941@sss.pgh.pa.us
Whole thread Raw
In response to Re: rotatelog / logrotate with PostgreSQL  (Roland Roberts <roland@astrofoto.org>)
Responses Re: rotatelog / logrotate with PostgreSQL
List pgsql-general
Roland Roberts <roland@astrofoto.org> writes:
>     Tom> Should work to just pipe the postmaster's stderr into it, eg
>     Tom>     postmaster ... 2>&1 | logrotate ...  &

> Huh?  logrotate moves a log file, it doesn't log anything.

My mistake; I was assuming that that script did something else.
What PG is able to work with is a script that absorbs input on
stdin and sends it to a rotatable logfile.  Surely there are some
of those out there.

> Does the postmaster close the log after writing?

If it did, how would it reopen it?  It doesn't know where its stderr
points...

            regards, tom lane

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: rotatelog / logrotate with PostgreSQL
Next
From: Thomas Beutin
Date:
Subject: Re: rotatelog / logrotate with PostgreSQL