pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Enable Syslog on Postgres
3+ messages / 3 participants
[nested] [flat]

* Enable Syslog on Postgres
@ 2007-11-28 10:55  Bansal, Gaurav (Gaurav) <gbansal@avaya.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Bansal, Gaurav (Gaurav) @ 2007-11-28 10:55 UTC (permalink / raw)
  To: pgsql-admin

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"
 
 
Also, I want to know how can I forward logs to a syslog server installed
on a machine different from database server's machine.
 
Any help/ pointer is much appreciated.
 
Regards
Gaurav
 
 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Enable Syslog on Postgres
@ 2007-11-29 14:46  Jeff Larsen <jlar310@gmail.com>
  parent: Bansal, Gaurav (Gaurav) <gbansal@avaya.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Jeff Larsen @ 2007-11-29 14:46 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Enable Syslog on Postgres
@ 2007-11-29 17:18  Joshua D. Drake <jd@commandprompt.com>
  parent: Bansal, Gaurav (Gaurav) <gbansal@avaya.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Joshua D. Drake @ 2007-11-29 17:18 UTC (permalink / raw)
  To: Bansal, Gaurav (Gaurav) <gbansal@avaya.com>; +Cc: pgsql-admin

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

On Wed, 28 Nov 2007 18:55:38 +0800
"Bansal, Gaurav (Gaurav)" <gbansal@avaya.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-----


^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-11-29 17:18 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-28 10:55 Enable Syslog on Postgres Bansal, Gaurav (Gaurav) <gbansal@avaya.com>
2007-11-29 14:46 ` Jeff Larsen <jlar310@gmail.com>
2007-11-29 17:18 ` Joshua D. Drake <jd@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox