Using syslog on pg for Windows

On Wed, Jan 02, 2008 at 11:17:52PM -0800, Goboxe wrote:

Hi,

What are required to be configured in order to send logs to
remote syslog server for pg running on Windows platform?

In http://pgfouine.projects.postgresql.org/tutorial.html , it says
"You can set syslog to send the log to another server through the
network with @ip.ad.dr.ess."

So try to update postgresql.conf

syslog_facility = 'x.x.x.x'

or

syslog_facility = '@x.x.x.x'

But it still does not work.

Any tips?

PostgreSQL on Win32 doesn't support syslog logging. You'll have to log to a
file and have an outside tool transfer that file to where youn eed it.

//Magnus

On Jan 4, 2008 8:33 AM, Magnus Hagander <magnus@hagander.net> wrote:

On Wed, Jan 02, 2008 at 11:17:52PM -0800, Goboxe wrote:

Hi,

What are required to be configured in order to send logs to
remote syslog server for pg running on Windows platform?

In http://pgfouine.projects.postgresql.org/tutorial.html , it says
"You can set syslog to send the log to another server through the
network with @ip.ad.dr.ess."

So try to update postgresql.conf

syslog_facility = 'x.x.x.x'

or

syslog_facility = '@x.x.x.x'

But it still does not work.

Any tips?

PostgreSQL on Win32 doesn't support syslog logging. You'll have to log to a
file and have an outside tool transfer that file to where youn eed it.

PostgreSQL does, however, support logging to Windows Event Log. From
there you could implement software to ship Event Log to remote syslog.

--
Jeff

On Jan 4, 11:22 pm, jlar...@gmail.com ("Jeff Larsen") wrote:

On Jan 4, 2008 8:33 AM, Magnus Hagander <mag...@hagander.net> wrote:

On Wed, Jan 02, 2008 at 11:17:52PM -0800, Goboxe wrote:

Hi,

What are required to be configured in order to send logs to
remote syslog server for pg running on Windows platform?

Inhttp://pgfouine.projects.postgresql.org/tutorial.html, it says
"You can set syslog to send the log to another server through the
network with @ip.ad.dr.ess."

So try to update postgresql.conf

syslog_facility = 'x.x.x.x'

or

syslog_facility = '...@x.x.x.x'

But it still does not work.

Any tips?

PostgreSQL on Win32 doesn't support syslog logging. You'll have to log to a
file and have an outside tool transfer that file to where youn eed it.

PostgreSQL does, however, support logging to Windows Event Log. From
there you could implement software to ship Event Log to remote syslog.

--
Jeff

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match- Hide quoted text -

- Show quoted text -

Hi,

Thanks for noth pointers. I'll try it.

Goboxe.