Skip site navigation (1) Skip section navigation (2)

Re: Enable Syslog on Postgres

From: "Jeff Larsen" <jlar310(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Enable Syslog on Postgres
Date: 2007-11-29 14:46:40
Message-ID: d1f9b6f00711290646v780aea4am725928566c90fff5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
> I have installed Postgres 8.2.5 on windows xp machine using the windows
> installer. I am trying to enable syslogs on Postgres so that all Postgress
> logs should be forwarded Syslog server. I have installed Syslog server
> WinSyslog on the same machine.
>
> I have modified 'log_destination' parameter value in postgresql.conf to
> 'syslog'. However, the database server fails to start and print following
> error message:
>
> FATAL:  invalid value for parameter "log_destination": "syslog"

Well, the PG docs don't exactly say that syslog is not supported on
Windows, but since syslog is not native to windows, I would guess that
it is not supported in that situation. However, PG does support
'eventlog' on windows systems. Someone please correct me if my
assumptions are wrong.

> Also, I want to know how can I forward logs to a syslog server installed on
> a machine different from database server's machine.

Local services do not typically send syslog messages directly to
remote syslogs, but, if you are on Linux/Unix you can configure the
local syslog daemon to forward certain things to another syslog
server.

For your situation, perhaps send PG logs to eventlog, then look for
Windows software to forward eventlog to a remote syslog. I know
something like that exists, but I've never actually used it.

Better yet, if your XP box has the resources, install the free VMware
Server and run PG in a Linux virtual machine.

Jeff

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2007-11-29 15:20:56
Subject: Re: Why dos select work when pg_dump fails?
Previous:From: Darren ReedDate: 2007-11-29 08:07:03
Subject: Why dos select work when pg_dump fails?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group