Am 2007-08-01 12:54:23, schrieb Tony Heal: > I am trying to move my postgresql (v7.4) logging out of the syslog and > into a postgres.log. I want to do this so I can > turn on logging full bore and have logrotate keep the logs to a > reasonable size. > > Here is my problem. Postgresql v7.4 will either log to STDOUT, syslog > or none. I have been looking at syslog.conf and > trying to set this up and I have what looks good, but I still get the > entries in the syslog. Here is what I have for > syslog.conf > > > > Local0.* /var/log/postgresql/postgres.log
----[ '/etc/syslog.conf' ]----------------------------
local0.* -/var/log/postgresql/postgres.log
------------------------------------------------------
and then:
----[ '/etc/postgresql/7.4/main/postgresql.conf' ]----
syslog = 2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
------------------------------------------------------
Thanks, Greetings and nice Day
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSN LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)
signature.pgp
Description: Digital signature
