pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
To: pgsql-admin@postgresql.org
Subject: Re: 8.3 RC1 - Logging and filenames
Date: Sat, 12 Jan 2008 16:18:08 +0000
Message-ID: <33671a790801120818i31f126b9ueac31f33ddb23063@mail.gmail.com> (raw)
In-Reply-To: <12963.1200011400@sss.pgh.pa.us>
References: <33671a790801101445j7f3c8644wf41c1e6fced8bedc@mail.gmail.com>
	<12716.1200010137@sss.pgh.pa.us>
	<20080110162258.4b0d4991@commandprompt.com>
	<12963.1200011400@sss.pgh.pa.us>

Hi all,

But surely if the rotation is disabled, PostgreSQL will just append to the
log if it exists (hence the extra option of "truncate on rotation?")

Many services use a single log file and just keep adding to it - that's the
way I'd prefer to set PostgreSQL up, simply so I can predict what the log
file's name is.  Our rotation system will then rotate the log and keep the
name in the same format as all our other services.

Andy

On 1/11/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Joshua D. Drake" <jd@commandprompt.com> writes:
> > Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >> You don't really have any choice about the matter --- Postgres will
> >> not use a single fixed filename because that would be guaranteed to
> >> lose log entries across a rotation.




> Unless he is using syslog?
>
> True, if you really dislike the way that the built-in log collector
> works, syslog is probably your best alternative.
>
>                         regards, tom lane
>

view thread (6+ messages)  latest in thread

Message-ID: <33671a790801120818i31f126b9ueac31f33ddb23063@mail.gmail.com>
Permalink:  ../33671a790801120818i31f126b9ueac31f33ddb23063@mail.gmail.com/
Also on:    postgresql.org/message-id/33671a790801120818i31f126b9ueac31f33ddb23063@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: andy.shellam-lists@mailnetwork.co.uk
  Subject: Re: 8.3 RC1 - Logging and filenames
  In-Reply-To: <33671a790801120818i31f126b9ueac31f33ddb23063@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox