no more /var/log/postgres.log in latest debian package?
Hello,
In debian's latest postgresql (7.1.3-7) package debugging is no longer
sent to /var/log/postgresql.log which is annoying as it pollutes the
syslog with tons of extraneous data.
I tried using a /etc/syslog.conf directive of
postgresql.* /var/log/postgresql.log
and
*.local0 /var/log/postgresql.log
but it does nothing.
Thanks in advance for any suggestion,
--
PHEDRE: Mais quelque juste orgueil qu'inspire un sang si beau,
Le crime d'une m�re est un pesant fardeau.
(Ph�dre, J-B Racine, acte 3, sc�ne 3)
Edit /etc/postgresql/postgresql.conf and set syslog = 0
if syslog = 2 then it goes to syslog (I believe that's the default for debian)
if syslog = 1 then I think it goes to both syslog and stdout
if syslog = 0 it doesn't go into syslog at all, only stdout
Then make sure that pg_ctl is passed the "-l" option (that's a lowercase L)
so that it sends the stdout to the correct file. I added:
POSTGRES_LOG=/var/log/postgres.log
to /usr/lib/postgresql/bin/postgresql-startup. It certainly seems as though
there should be an easier way, doesn't it? Maybe there is a better way to
pass it as an environment variable. Anyway, I guess that isn't too bad. It
gets the output in the right file. I hope they make it cleaner for the 7.2
packages.
Let me know if you find a better way.
Regards,
Jeff
Show quoted text
On Friday 08 February 2002 01:23 am, you wrote:
Hello,
In debian's latest postgresql (7.1.3-7) package debugging is no longer
sent to /var/log/postgresql.log which is annoying as it pollutes the
syslog with tons of extraneous data.I tried using a /etc/syslog.conf directive of
postgresql.* /var/log/postgresql.log
and
*.local0 /var/log/postgresql.log
but it does nothing.
Thanks in advance for any suggestion,
On Fri, Feb 08, 2002 at 02:28:04AM -0800, Jeff Davis wrote:
Edit /etc/postgresql/postgresql.conf and set syslog = 0
if syslog = 2 then it goes to syslog (I believe that's the default for debian)
if syslog = 1 then I think it goes to both syslog and stdout
if syslog = 0 it doesn't go into syslog at all, only stdoutThen make sure that pg_ctl is passed the "-l" option (that's a lowercase L)
so that it sends the stdout to the correct file. I added:
POSTGRES_LOG=/var/log/postgres.log
to /usr/lib/postgresql/bin/postgresql-startup. It certainly seems as though
there should be an easier way, doesn't it? Maybe there is a better way to
pass it as an environment variable. Anyway, I guess that isn't too bad. It
gets the output in the right file. I hope they make it cleaner for the 7.2
packages.
Thanks a lot it works fine now!
--
THESEE: Mais l'ingrat toutefois ne m'est point �chapp�.
Une immortelle main de sa perte est charg�e.
(Ph�dre, J-B Racine, acte 4, sc�ne 4)
On fre, feb 08, 2002 at 02:28:04 -0800, Jeff Davis wrote:
Edit /etc/postgresql/postgresql.conf and set syslog = 0
if syslog = 2 then it goes to syslog (I believe that's the default for debian)
if syslog = 1 then I think it goes to both syslog and stdout
if syslog = 0 it doesn't go into syslog at all, only stdoutThen make sure that pg_ctl is passed the "-l" option (that's a lowercase L)
so that it sends the stdout to the correct file. I added:
POSTGRES_LOG=/var/log/postgres.log
to /usr/lib/postgresql/bin/postgresql-startup. It certainly seems as though
there should be an easier way, doesn't it? Maybe there is a better way to
pass it as an environment variable. Anyway, I guess that isn't too bad. It
gets the output in the right file. I hope they make it cleaner for the 7.2
packages.Let me know if you find a better way.
I missed most of this thread so I hope I'm not repeating something here. There's
an outcommented line in /etc/postgresql/postmaster.conf file:
# POSTGRES_LOG=/var/log/postgres.log
Removing the # has the same effect as what you describe above, but you don't
have to alter a script that's overwritten on the next upgrade. Maybe
postmaster.conf is not marked as a config file in the package, so it get's
overwritten when upgrading? If so maybe one should file a bug report?
/Daniel