* Joshua D. Drake (j...@commandprompt.com) wrote: > On Tue, 2009-01-13 at 16:58 -0500, Tom Lane wrote: > > You might think you do, but it won't work with PG; external rotators > > only work with programs that respond to SIGHUP by re-opening their log > > files. > > copytruncate resolves this issue does it not? On that note it seems > maybe that is a smart idea (to reopen the log). PostgreSQL will already > allow you to arbitrarily change the log_filename with a HUP.
It would certainly be nice to have a way to cause PostgreSQL to reopen
it's log file without disrupting operation. That's a much better option
than using copytruncate.
Thanks,
Stephen
signature.asc
Description: Digital signature
