From: | Jeff Davis <list-pgsql-general(at)dynworks(dot)com> |
---|---|
To: | Louis-David Mitterrand <vindex(at)apartia(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: no more /var/log/postgres.log in latest debian package? |
Date: | 2002-02-08 10:28:04 |
Message-ID: | 200202081031.CAA28283@mail.ucsd.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
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,
From | Date | Subject | |
---|---|---|---|
Next Message | Louis-David Mitterrand | 2002-02-08 10:43:49 | Re: no more /var/log/postgres.log in latest debian package? |
Previous Message | Mayan | 2002-02-08 10:21:35 | Debian package for pgsql-7.1.3 |