Re: way to turn off epochs in log_filename - Mailing list pgsql-admin

From Tom Lane
Subject Re: way to turn off epochs in log_filename
Date
Msg-id 27413.1193435100@sss.pgh.pa.us
Whole thread Raw
In response to Re: way to turn off epochs in log_filename  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Find the Person Connected to a Database  (Naomi Walker <nwalker@mhs.mphasis.com>)
Re: way to turn off epochs in log_filename  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> If logrotate would work, we'd never have bothered writing our own
>> substitute.  But there's no way for logrotate to repoint postmaster's
>> stderr into other files.

> Uh... can't we just use copytruncate with logroate?

How's that going to reset the offsets in the stderr file descriptors of
the various PG processes?  There might be some platforms and
configurations where it will work, but I wouldn't tout it as a portable
approach.  I'd also suppose that there are race conditions involved:
you'll either lose or duplicate messages that are emitted while
copytruncate works.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: way to turn off epochs in log_filename
Next
From: Naomi Walker
Date:
Subject: Find the Person Connected to a Database