Re: log_destination - Mailing list pgsql-pkg-debian

From Andres Freund
Subject Re: log_destination
Date
Msg-id 20130306102405.GL13803@alap2.anarazel.de
Whole thread Raw
In response to Re: log_destination  (Christoph Berg <cb@df7cb.de>)
Responses Re: log_destination  (Christoph Berg <cb@df7cb.de>)
List pgsql-pkg-debian
On 2013-03-06 11:05:58 +0100, Christoph Berg wrote:
> Re: Magnus Hagander 2013-03-05 <CABUevEyxztj1myF_sdpujeQrKzgfH+DAQd2sNfD-uxizw_9s8g@mail.gmail.com>
> > Is there a particular reason why we're not using the postgresql log
> > collector in the debian packages, instead relying on pg_ctl -l, other
> > than this being legacy from back before we even had the log collector?
>
> The problem is that errors during early startup (syntax errors in
> postgresql.conf, port unavailable, shmmax, whatever) will not go into
> the logging collector, but will still appear in the "pg_ctl -l" log
> file. Changing the default here would mean the admin had to check two
> log files if the server doesn't even start.
>
> pg_ctl -l ~/logfile -o '--logging-collector=on --log-destination=stderr --log-directory=pg_log --ffo=bla' start
>
> -> complains about "ffo" in ~/logfile
>
> Apart from that, I agree that the logging collector would be a lot
> nicer than the current logrotate rules with the "copytruncate"
> insanity.

Both pg_ctl and the logging collector seem to open files in O_APPEND
mode. So - provided we could figure out the correct filename - they
could just log to the same file.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-pkg-debian by date:

Previous
From: Christoph Berg
Date:
Subject: Re: log_destination
Next
From: Christoph Berg
Date:
Subject: Re: log_destination