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,
