Re: [NOVICE] Postgres Syslog

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?

Thanks,
Darryl

-----Original Message-----
From: Steve Crawford [mailto:scrawford@pinpointresearch.com]
Sent: Friday, March 28, 2003 3:41 PM
To: Delao, Darryl W; 'pgsql-novice@postgresql.org';
'pgsql-general@postgresql.org'
Subject: Re: [NOVICE] Postgres Syslog

That's a syslog issue, not a PostgreSQL issue. Read your syslog.conf man
pages. For many versions of syslog you use:
local3.*<tab>@host
instead of
local3.*<tab>/var/log/mylogfile

I just used local3 as an example - substitute the syslog facility name to
which you are routing your postgresql messages.

Remember that syslog expects tabs, not spaces between the facility/priority
and the destination (at least in all the syslogs I have used - check your
man
pages).

Also be sure that the host is accepting remote syslog messages - most
default
setups don't allow this. You will probably need to set a flag to allow
remote
message logging.

Cheers,
Steve


On Friday 28 March 2003 8:26 am, Delao, Darryl W wrote:
> I am trying to setup the postgres.conf to send all postgres messages to a
> syslog server.  However, in the conf file there is no place to define the
> host.  I will be sending to an external host.  How do I tell the conf file
> to send syslogs to an outside host?
>
> Thank you,
> Darryl
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html