Re: --enable-syslog and Solaris 7

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Andrew Sullivan <andrew(at)libertyrms(dot)com>
Cc: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: --enable-syslog and Solaris 7
Date: 2001-08-30 21:19:53
Message-ID: 20010830211956.108E62AB44@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jue 30 Ago 2001 14:02, you wrote:
> On Thu, Aug 30, 2001 at 11:47:07AM -0300, Mart?n Marqu?s wrote:
> > > And, in /etc/syslog.conf, I have
> > >
> > > #Postgres logging
> > >
> > > local1.* /opt/OXRS/logs/postgres/pg.log
> >
> > On Solaris, this those not work!
> > BTW, why local1? It should be postgres (thats the ident).
>
> I thought you had to specify the facility. That's what the manpage
> for syslog.conf says, anyway:
>
> The selector field contains a semicolon-separated list of
> priority specifications of the form:
>
> facility.level [ ; facility.level ]
>
> where facility is a system facility, or comma-separated list
> of facilities, and level is an indication of the severity of
> the condition being logged. Recognized values for facility
> include:
>
> [user, kern, . . . local0-7 . . .]

You are right about this:

I'll show you my configuration:

postgresql.conf:
#
# Syslog
#
#ifdef ENABLE_SYSLOG
syslog = 1 # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
#endif

/etc/syslog.conf:

local0.debug /var/log/postgresql

It worked for me!

>
> What's different about Solaris syslog (are the man pages wrong)?

Nothing, but you can't put something like this:

local0.* /var/log/postgresql

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-08-30 21:22:07 Re: Is that pgsql support the database partitioning?
Previous Message Doug McNaught 2001-08-30 21:17:03 Re: Query