Обсуждение: postgres, syslog and freeBSD
Hi list; I'm trying to get postgres & syslog to get along with no luck. I'm running freeBSD7 and postgres 8.3.1 Here's my postgres setup log_destination = 'syslog' #logging_collector = off syslog_facility = 'LOCAL0' syslog_ident = 'postgres' silent_mode = on log_min_duration_statement = 0 Here's my /etc/syslog.conf file: security.* /var/log/security auth.info;authpriv.info /var/log/auth.log mail.info /var/log/maillog lpr.info /var/log/lpd-errs ftp.info /var/log/xferlog cron.* /var/log/cron *.=debug /var/log/debug.log *.emerg * # uncomment this to log all writes to /dev/console to /var/log/ console.log #console.info /var/log/console.log # uncomment this to enable logging of all log messages to /var/log/ all.log # touch /var/log/all.log and chmod it to mode 600 before it will work #*.* /var/log/all.log # uncomment this to enable logging to a remote loghost named loghost #*.* @loghost # uncomment these if you're running inn # news.crit /var/log/news/news.crit # news.err /var/log/news/news.err # news.notice /var/log/news/news.notice !startslip *.* /var/log/slip.log !ppp *.* /var/log/ppp.log LOCAL0.* /var/log/pgsql I dont see any files show up in /var/log what am I doing wrong? Thanks in advance.. /Kevin
On Fri, May 30, 2008 at 12:35 AM, kevin kempter <kevin@kevinkempterllc.com> wrote:
maybe a permission issue ? can postgres write on /var/log ? Had the same problem with a linux some time ago ;)
Greetings ;)
--
Mailed by:
UnReAl4U - unreal4u
ICQ #: 54472056
www: http://www.chw.net/
Hi list;
I'm trying to get postgres & syslog to get along with no luck. I'm running freeBSD7 and postgres 8.3.1
Here's my postgres setup
log_destination = 'syslog'
#logging_collector = off
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
silent_mode = on
log_min_duration_statement = 0
Here's my /etc/syslog.conf file:
security.* /var/log/security
auth.info;authpriv.info /var/log/auth.log
mail.info /var/log/maillog
lpr.info /var/log/lpd-errs
ftp.info /var/log/xferlog
cron.* /var/log/cron
*.=debug /var/log/debug.log
*.emerg *
# uncomment this to log all writes to /dev/console to /var/log/console.log
#console.info /var/log/console.log
# uncomment this to enable logging of all log messages to /var/log/all.log
# touch /var/log/all.log and chmod it to mode 600 before it will work
#*.* /var/log/all.log
# uncomment this to enable logging to a remote loghost named loghost
#*.* @loghost
# uncomment these if you're running inn
# news.crit /var/log/news/news.crit
# news.err /var/log/news/news.err
# news.notice /var/log/news/news.notice
!startslip
*.* /var/log/slip.log
!ppp
*.* /var/log/ppp.log
LOCAL0.* /var/log/pgsql
I dont see any files show up in /var/log
what am I doing wrong?
Thanks in advance..
/Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
maybe a permission issue ? can postgres write on /var/log ? Had the same problem with a linux some time ago ;)
Greetings ;)
--
Mailed by:
UnReAl4U - unreal4u
ICQ #: 54472056
www: http://www.chw.net/
Camilo Sperberg wrote: > On Fri, May 30, 2008 at 12:35 AM, kevin kempter > <kevin@kevinkempterllc.com <mailto:kevin@kevinkempterllc.com>> wrote: > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org > <mailto:pgsql-admin@postgresql.org>) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > > > maybe a permission issue ? can postgres write on /var/log ? Had the same > problem with a linux some time ago ;) Would that matter? Doesn't it go through syslog? Joshua D. Drake
Στις Friday 30 May 2008 07:35:19 ο/η kevin kempter έγραψε: > Hi list; > > I'm trying to get postgres & syslog to get along with no luck. I'm > running freeBSD7 and postgres 8.3.1 > > Here's my postgres setup > > log_destination = 'syslog' > #logging_collector = off > syslog_facility = 'LOCAL0' > syslog_ident = 'postgres' > silent_mode = on > log_min_duration_statement = 0 > > > Here's my /etc/syslog.conf file: > > > security.* /var/log/security > auth.info;authpriv.info /var/log/auth.log > mail.info /var/log/maillog > lpr.info /var/log/lpd-errs > ftp.info /var/log/xferlog > cron.* /var/log/cron > *.=debug /var/log/debug.log > *.emerg * > # uncomment this to log all writes to /dev/console to /var/log/ > console.log > #console.info /var/log/console.log > # uncomment this to enable logging of all log messages to /var/log/ > all.log > # touch /var/log/all.log and chmod it to mode 600 before it will work > #*.* /var/log/all.log > # uncomment this to enable logging to a remote loghost named loghost > #*.* @loghost > # uncomment these if you're running inn > # news.crit /var/log/news/news.crit > # news.err /var/log/news/news.err > # news.notice /var/log/news/news.notice > !startslip > *.* /var/log/slip.log > !ppp > *.* /var/log/ppp.log > LOCAL0.* /var/log/pgsql change that to local0.* /var/log/pgsql.log (lowercase, also a .log suffix is more standard) make sure the /var/log/pgsql.log file exists (create it with vi), and then change its permissions to smth like -rw------- 1 root wheel 109274 30 Μαϊ 09:00 /var/log/pgsql.log This works in my FreeBSD system, although with 7.4.*, i dont have any 8.3.1 handy at the moment. > > > > I dont see any files show up in /var/log > > what am I doing wrong? > > Thanks in advance.. > > /Kevin > > -- Achilleas Mantzios
did you kill -hup syslogd after you changed syslog.conf
On Thu, May 29, 2008 at 11:04 PM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
Στις Friday 30 May 2008 07:35:19 ο/η kevin kempter έγραψε:change that to> Hi list;
>
> I'm trying to get postgres & syslog to get along with no luck. I'm
> running freeBSD7 and postgres 8.3.1
>
> Here's my postgres setup
>
> log_destination = 'syslog'
> #logging_collector = off
> syslog_facility = 'LOCAL0'
> syslog_ident = 'postgres'
> silent_mode = on
> log_min_duration_statement = 0
>
>
> Here's my /etc/syslog.conf file:
>
>
> security.* /var/log/security
> auth.info;authpriv.info /var/log/auth.log
> mail.info /var/log/maillog
> lpr.info /var/log/lpd-errs
> ftp.info /var/log/xferlog
> cron.* /var/log/cron
> *.=debug /var/log/debug.log
> *.emerg *
> # uncomment this to log all writes to /dev/console to /var/log/
> console.log
> #console.info /var/log/console.log
> # uncomment this to enable logging of all log messages to /var/log/
> all.log
> # touch /var/log/all.log and chmod it to mode 600 before it will work
> #*.* /var/log/all.log
> # uncomment this to enable logging to a remote loghost named loghost
> #*.* @loghost
> # uncomment these if you're running inn
> # news.crit /var/log/news/news.crit
> # news.err /var/log/news/news.err
> # news.notice /var/log/news/news.notice
> !startslip
> *.* /var/log/slip.log
> !ppp
> *.* /var/log/ppp.log
> LOCAL0.* /var/log/pgsql
local0.* /var/log/pgsql.log
(lowercase, also a .log suffix is more standard)
make sure the /var/log/pgsql.log file exists (create it with vi),
and then change its permissions to smth like
-rw------- 1 root wheel 109274 30 Μαϊ 09:00 /var/log/pgsql.log
This works in my FreeBSD system, although with 7.4.*, i dont have any 8.3.1 handy at the moment.>Achilleas Mantzios
>
>
> I dont see any files show up in /var/log
>
> what am I doing wrong?
>
> Thanks in advance..
>
> /Kevin
>
>
--
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
1) syslog.conf: !postgres *.* /var/log/postgresql.log 2) in your root shell: touch /var/log/postgresql.log 3) don't forget newsyslog.conf 4) don't forget man syslog.conf On Thu, 29 May 2008 22:35:19 -0600 kevin kempter <kevin@kevinkempterllc.com> wrote: > Hi list; > > I'm trying to get postgres & syslog to get along with no luck. I'm > running freeBSD7 and postgres 8.3.1 > > Here's my postgres setup > > log_destination = 'syslog' > #logging_collector = off > syslog_facility = 'LOCAL0' > syslog_ident = 'postgres' > silent_mode = on > log_min_duration_statement = 0 > > > Here's my /etc/syslog.conf file: > > > security.* /var/log/security > auth.info;authpriv.info /var/log/auth.log > mail.info /var/log/maillog > lpr.info /var/log/lpd-errs > ftp.info /var/log/xferlog > cron.* /var/log/cron > *.=debug /var/log/debug.log > *.emerg * > # uncomment this to log all writes to /dev/console to /var/log/ > console.log > #console.info /var/log/console.log > # uncomment this to enable logging of all log messages to /var/log/ > all.log > # touch /var/log/all.log and chmod it to mode 600 before it will work > #*.* /var/log/all.log > # uncomment this to enable logging to a remote loghost named loghost > #*.* @loghost > # uncomment these if you're running inn > # news.crit /var/log/news/news.crit > # news.err /var/log/news/news.err > # news.notice /var/log/news/news.notice > !startslip > *.* /var/log/slip.log > !ppp > *.* /var/log/ppp.log > LOCAL0.* /var/log/pgsql > > > > I dont see any files show up in /var/log > > what am I doing wrong? > > Thanks in advance.. > > /Kevin > > -- Sincerely, Gergely Czuczy Harmless Digital Bt mailto: gergely.czuczy@harmless.hu Tel: +36-30-9702963
Вложения
Hello, kevin kempter wrote: > log_destination = 'syslog' > #logging_collector = off > syslog_facility = 'LOCAL0' > syslog_ident = 'postgres' > silent_mode = on > log_min_duration_statement = 0 > > Here's my /etc/syslog.conf file: > > LOCAL0.* /var/log/pgsql > > I dont see any files show up in /var/log > > what am I doing wrong? According to man-page of syslog.conf the name of facility is "local0", but not "LOCAL0": ---- The facility describes the part of the system generating the message, and is one of the following keywords: auth, authpriv, console, cron, daemon, ftp, kern, lpr, mail, mark, news, ntp, security, syslog, user, uucp and local0 through local7. ---- Also it might be that syslog do not create this file, try to create it by self: # touch /var/log/pgsql With regards, Alexander Vysokovskih
Hello, kevin kempter wrote: > log_destination = 'syslog' > #logging_collector = off > syslog_facility = 'LOCAL0' > syslog_ident = 'postgres' > silent_mode = on > log_min_duration_statement = 0 > > Here's my /etc/syslog.conf file: > > LOCAL0.* /var/log/pgsql > > I dont see any files show up in /var/log > > what am I doing wrong? According to man-page of syslog.conf the name of facility is "local0", but not "LOCAL0": ---- The facility describes the part of the system generating the message, and is one of the following keywords: auth, authpriv, console, cron, daemon, ftp, kern, lpr, mail, mark, news, ntp, security, syslog, user, uucp and local0 through local7. ---- Also it might be that syslog do not create this file, try to create it by self: # touch /var/log/pgsql With regards, Alexander Vysokovskih