Re: way to turn off epochs in log_filename

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: David Lowry <dlowry(at)bju(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: way to turn off epochs in log_filename
Date: 2007-10-26 21:40:05
Message-ID: 20071026144005.3aa6cc29@scratch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 26 Oct 2007 17:33:15 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> David Lowry <dlowry(at)bju(dot)edu> writes:
> > The docs state that if there are no %-escapes in log_filename,
> > then it will add the epoch onto the end of the log filename. Is
> > there any way to turn off this behavior and just use the filename
> > specified in log_filename? I'd like have all the log data written
> > to a file like postgresql.log and let logrotate do the rotation.
>
> 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? That way
we don't have to repoint. That is how we do it anyway... Or am I missing
something?

Joshua D. Drake

>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 1: if posting/reading
> through Usenet, please send an appropriate subscribe-nomail command
> to majordomo(at)postgresql(dot)org so that your message can get through to
> the mailing list cleanly
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-10-26 21:45:00 Re: way to turn off epochs in log_filename
Previous Message Tom Lane 2007-10-26 21:33:15 Re: way to turn off epochs in log_filename