RE: [GENERAL] Transaction logging - Mailing list pgsql-general

From Daryl W. Dunbar
Subject RE: [GENERAL] Transaction logging
Date
Msg-id 003901be5f55$237dabd0$1445e59b@ddunbar.eni.net
Whole thread Raw
In response to Re: [GENERAL] Transaction logging  (jim@reptiles.org (Jim Mercer))
List pgsql-general
I evoke postmaster this way from an rc script:

su - postgres -c "/usr/local/pgsql/bin/postmaster -d 2 -i 2>&1 |
logger -p local7.notice -tPOSTMASTER &"

And I get copious debugging information (-d takes 1, 2 or 3)...

Don't forget to edit /etc/syslog.conf to direct local7.notice to a
file, ala:

local7.notice                           /var/adm/postmaster.log


DwD

> -----Original Message-----
> From: owner-pgsql-general@postgreSQL.org
> [mailto:owner-pgsql-general@postgreSQL.org]On Behalf Of Jim Mercer
> Sent: Tuesday, February 23, 1999 12:18 PM
> To: Thomas Reinke
> Cc: pgsql-general@postgreSQL.org
> Subject: Re: [GENERAL] Transaction logging
>
>
> > Don't use syslog under any circumstances!!!!
>
> on a slightly different tact, it would be a good
> thing(tm) if postmaster
> and the postgres backends used syslog for logging debug
> and other information.
>
> i've tried enabling debug via the postmaster command, and
> haven't ever seen
> anything overly useful.
>
> --
> [ Jim Mercer    Reptilian Research      jim@reptiles.org
>  +1 416 410-5633 ]
> [ The telephone, for those of you who  have forgotten,
> was a commonly used ]
> [ communications technology in the days before electronic
> mail.            ]
> [ They're still easy to find in most large cities. --
> Nathaniel Borenstein ]
>


pgsql-general by date:

Previous
From: Dustin Sallings
Date:
Subject: Re: [GENERAL] non-Transaction logging
Next
From: mapaquin@cca.qc.ca (Marc Andre Paquin)
Date:
Subject: Looking for a ps tutorial copy