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 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.
>
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
