Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using syslog on pg for Windows

Using syslog on pg for Windows

From
Goboxe
Date:
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?

Thanks,
Goboxe

Re: Using syslog on pg for Windows

From
Magnus Hagander
Date:
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

Re: Using syslog on pg for Windows

From
"Jeff Larsen"
Date:
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

Re: Using syslog on pg for Windows

From
Goboxe
Date:
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.