Re: rotatelog / logrotate with PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roland Roberts <roland(at)astrofoto(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: rotatelog / logrotate with PostgreSQL
Date: 2002-09-24 18:09:01
Message-ID: 7067.1032890941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Roland Roberts <roland(at)astrofoto(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-09-24 18:48:32 Re: subselect bug (was Re: [GENERAL] DBLink: interesting issue)
Previous Message scott.marlowe 2002-09-24 17:33:18 Re: [GENERAL] PGXLOG variable worthwhile?