Re: [NOVICE] Postgres Syslog

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: "Delao, Darryl W" <ddelao(at)ou(dot)edu>
Cc: "'Steve Crawford'" <scrawford(at)pinpointresearch(dot)com>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [NOVICE] Postgres Syslog
Date: 2003-04-03 18:53:06
Message-ID: Pine.LNX.4.44.0304032150410.15348-100000@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hi,

On Mon, 31 Mar 2003, Delao, Darryl W wrote:

> How about sending log messages to a single file. I see a file under var/log
> called pgsql, but it has nothing in it. What do I need to enable in the
> postgreql.conf to start logging to a local file?

Start PostgreSQL with -l parameter:

pg_ctl .... -l /var/log/pgsql

If you are using an rpm-based installation; edit the init script of
PostgreSQL (usually under /etc/init.d) and add -l parameter to start line,

i.e.

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -l /var/log/pgsql -D
$PGDATA -p /usr/bin/postmaster start > /dev/null 2>&1" < /dev/null

Regards,
--
Devrim GUNDUZ
devrim(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)tr
http://www.gunduz.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-03 18:54:20 Re: unable to dump database, toast errors
Previous Message Medi Montaseri 2003-04-03 18:47:13 Re: pgsql password when FreeBSD boots -- what's usual?

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-04-03 19:14:59 Re: Translating Oracle CREATE TRIGGER statement
Previous Message Don Patou 2003-04-03 18:24:40 question about auto increment like