--On Tuesday, September 30, 2003 13:44:04 +0800 Christopher Kings-Lynne
<chriskl@familyhealth.com.au> wrote:
> Hi Guys,
>
> I just spent the last half hour learning syslog and log rolling with
> postgres. Would there be objections to me expanding on the syslog
> sections in the docs?
>
> http://developer.postgresql.org/docs/postgres/logfile-maintenance.html
>
> I want to:
>
> * Add a link to the third paragraph there where it says to set syslog to
> 2 that goes to the syslog section of the SET parameters page.
>
> * Give an example of how to configure your syslog.conf to log to a
> separate postgres log. eg:
>
> "Depending on your system, to have syslog log PostgreSQL entries to a
> particular file, add something like this to the top of your
> /etc/syslog.conf:
>
># Log all 'postgres' events to /var/log/pgsql
> !postgres
> *.* /var/log/pgsql
># Nothing after this line applies to 'postgres'
> !-postgres
> "
a more standard (non-FreeBSD specific) answer is:
local0.* /var/log/postgres.log
(this also works on FreeBSD, btw).
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749