Re: Enable Syslog on Postgres

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Bansal, Gaurav (Gaurav)" <gbansal(at)avaya(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Enable Syslog on Postgres
Date: 2007-11-29 17:18:08
Message-ID: 20071129091808.0014cc47@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 28 Nov 2007 18:55:38 +0800
"Bansal, Gaurav (Gaurav)" <gbansal(at)avaya(dot)com> wrote:

> Hi,
>
> 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"

To my knowledge you can't use syslog on win32 with PostgreSQL. Use
eventlog.

Joshua D. Drake

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHTvRTATb/zqfZUUQRAo0CAJ498CBOaKoA76liFBi8IpqFH7z6rACfcdbm
xQTLkYi+T3aKpdn1eNw7qoo=
=DckU
-----END PGP SIGNATURE-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Campbell, Lance 2007-11-29 21:32:59 clear statistics in pg_stat
Previous Message Tom Lane 2007-11-29 15:20:56 Re: Why dos select work when pg_dump fails?