"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes:
> Tom Lane <tgl@xxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
