Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AA0FB9FC755 for ; Fri, 26 Oct 2007 17:25:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 68045-02 for ; Fri, 26 Oct 2007 17:25:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by postgresql.org (Postfix) with ESMTP id 1425F9FA637 for ; Fri, 26 Oct 2007 17:25:28 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so1336961waf for ; Fri, 26 Oct 2007 13:25:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=l9nH4VeyrmZxjKAJWZS/a0o7MYr3yH50Bgc4FsqR59w=; b=g6231OcMP78ZfbY9MrjGIG6I7JoN8SP17sn+GnWgAqJUmSt0Du0bG7QKetzWdetWO+pso1RW4RpS5A2KxQLMrb2JddumXMi+ECgF74pTxhUxhTSoQrZDa0Noxw7YGR2rW62mkWgoeZZTS7OsYkzqvFLrGnBAxvOmPnVUF5gUNpE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hDmy3y4lhhqjFQZvVq/YW4ArZtz7l0hZRJXt9idRDEbs3HItLfYvNeMpftiy4khVy1bANlUyp9OhAOHQoSAGwgm2/flz3/rYvDioB2SdtZZCEixzltFYVteP9MXGm6xcngd4bW4GPMo9O4s5q8UJXEDImvcRsRBv9Sl6yPwVpdU= Received: by 10.114.124.1 with SMTP id w1mr3850233wac.1193430326659; Fri, 26 Oct 2007 13:25:26 -0700 (PDT) Received: by 10.114.197.19 with HTTP; Fri, 26 Oct 2007 13:25:26 -0700 (PDT) Message-ID: <4544e0330710261325k708348fbm5c04eea44fd7ccc7@mail.gmail.com> Date: Fri, 26 Oct 2007 15:25:26 -0500 From: "Peter Koczan" To: "David Lowry" Subject: Re: way to turn off epochs in log_filename Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/267 X-Sequence-Number: 27181 > 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. Correct me if I'm wrong, but I think you're trying to redirect stderr. Why not just use syslog? That's what I use and it works very nicely. Here are the relevant bits from postgresql.conf (that aren't related to log formatting and changed from the default). log_destination = 'syslog' syslog_facility = 'LOCAL1' Just make sure you pipe the syslog facility to postgresql.log, and then you can use logrotate. Peter