quick (and probably dumb) question

Started by ernie clinealmost 26 years ago2 messagesgeneral
Jump to latest
#1ernie cline
ernie.cline@ipgdirect.com

Hello all,
I just finished my very first postgresql installation (Version 7). I
already like it much better than oracle 8, which took me the better part
of a day to install. Anyway, I have a red-hat based VA Linux box, so I
followed the red-hat startup instructions, putting a file in
/etc/rc.d/init.d and a link in /etc/rc.d/rc5.d ... and I reconfigured
syslog so that local5.* goes to /var/log/postgres. Everything works
fine, except that postmaster messages go to /var/log/messages as well
... whats up with that? What do I have to change so that messages
doesn't get the database errors ... any help would be appreciated!
Thanks in advance.

-ernie

#2Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: ernie cline (#1)
Re: quick (and probably dumb) question

Hello all,
I just finished my very first postgresql installation (Version 7). I
already like it much better than oracle 8, which took me the better part
of a day to install. Anyway, I have a red-hat based VA Linux box, so I
followed the red-hat startup instructions, putting a file in
/etc/rc.d/init.d and a link in /etc/rc.d/rc5.d ... and I reconfigured
syslog so that local5.* goes to /var/log/postgres. Everything works
fine, except that postmaster messages go to /var/log/messages as well
... whats up with that? What do I have to change so that messages
doesn't get the database errors ... any help would be appreciated!
Thanks in advance.

-ernie

Do you have something like this in syslog.conf?

*.info;mail.none;authpriv.none /var/log/messages

Since PostgreSQL uses LOG_LOCAL0 log facility, changing to:

*.info;mail.none;authpriv.none;local0.none /var/log/messages

will do the trick. Hope this helps,
--
Tatstuo Ishii