Обсуждение: Postgres Remote Syslog

I have postgres logging to a local file on the machine.  However, now I want
to set it to where it will send its log messages to another machine on my
network.  I see no documentation out there on how to do that, nor in the
postgresql.conf is there anything to define a remote machine...any and all
help is greatly appreciated on this!

Darryl

"Delao, Darryl W" <ddelao@ou.edu> writes:
> I have postgres logging to a local file on the machine.  However, now I want
> to set it to where it will send its log messages to another machine on my
> network.  I see no documentation out there on how to do that, nor in the
> postgresql.conf is there anything to define a remote machine...any and all
> help is greatly appreciated on this!

You'd configure syslog to do that, not Postgres.  Read the syslog man
pages.

            regards, tom lane

----------  Forwarded Message  ----------

Subject: Re: [GENERAL] [NOVICE] Postgres Syslog
Date: Thu, 3 Apr 2003 14:30:00 -0500
From: Lamar Owen <lamar.owen@wgcr.org>
To: "Delao, Darryl W" <ddelao@ou.edu>, "'Steve Crawford'"
<scrawford@pinpointresearch.com>, "'pgsql-novice@postgresql.org'"
<pgsql-novice@postgresql.org>, "'pgsql-general@postgresql.org'"
<pgsql-general@postgresql.org>

On Monday 31 March 2003 09:02, 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?

You do this in the _syslog_ configuration, not in the PostgreSQL
configuration.  That is just the way syslog works: PostgreSQL contacts the
local syslogd, and logs its message using the syslog facility you define in
postgresql.conf.  What syslog does with that message is determined by
/etc/syslog.conf.  That could be any one of all sorts of things, including,
but not limited to, logging to a single file, logging to a remote syslog
server, logging to the system console, logging to a printer, etc.....and it's
all controlled in /etc/syslog.conf.  So 'man syslog.conf' and see what you
need to do.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-------------------------------------------------------

--
Aarni Ruuhimäki
Megative Tmi
KYMI.com

Pääsintie 26
45100 Kouvola

info@kymi.com / aarni.ruuhimaki@kymi.com

05 - 3755 035 / 050 - 4910 037
-------------------------------
Linux RedHat 7.3. / KDE 3.0
-------------------------------