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)
Attachment:
signature.pgp
Description: Digital signature