pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres, syslog and freeBSD
8+ messages / 7 participants
[nested] [flat]
* postgres, syslog and freeBSD
@ 2008-05-30 04:35 kevin kempter <kevin@kevinkempterllc.com>
2008-05-30 04:57 ` Re: postgres, syslog and freeBSD Camilo Sperberg <unreal4u@chilehardware.com>
2008-05-30 06:04 ` Re: postgres, syslog and freeBSD Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-05-30 07:38 ` Re: postgres, syslog and freeBSD CZUCZY Gergely <phoemix@harmless.hu>
2008-05-30 08:05 ` Re: postgres, syslog and freeBSD Alexander Vysokovskih <av@ural.org>
2008-05-30 08:39 ` Re: postgres, syslog and freeBSD Alexander Vysokovskih <av@ural.org>
0 siblings, 5 replies; 8+ messages in thread
From: kevin kempter @ 2008-05-30 04:35 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgres, syslog and freeBSD
2008-05-30 04:35 postgres, syslog and freeBSD kevin kempter <kevin@kevinkempterllc.com>
@ 2008-05-30 04:57 ` Camilo Sperberg <unreal4u@chilehardware.com>
2008-05-30 05:01 ` Re: postgres, syslog and freeBSD Joshua D. Drake <jd@commandprompt.com>
4 siblings, 1 reply; 8+ messages in thread
From: Camilo Sperberg @ 2008-05-30 04:57 UTC (permalink / raw)
To: kevin kempter <kevin@kevinkempterllc.com>; +Cc: pgsql-admin
On Fri, May 30, 2008 at 12:35 AM, 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
>
>
> --
> 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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgres, syslog and freeBSD
2008-05-30 04:35 postgres, syslog and freeBSD kevin kempter <kevin@kevinkempterllc.com>
2008-05-30 04:57 ` Re: postgres, syslog and freeBSD Camilo Sperberg <unreal4u@chilehardware.com>
@ 2008-05-30 05:01 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 8+ messages in thread
From: Joshua D. Drake @ 2008-05-30 05:01 UTC (permalink / raw)
To: Camilo Sperberg <unreal4u@chilehardware.com>; +Cc: kevin kempter <kevin@kevinkempterllc.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgres, syslog and freeBSD
2008-05-30 04:35 postgres, syslog and freeBSD kevin kempter <kevin@kevinkempterllc.com>
@ 2008-05-30 06:04 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-05-30 06:48 ` Re: postgres, syslog and freeBSD Medi Montaseri <montaseri@gmail.com>
4 siblings, 1 reply; 8+ messages in thread
From: Achilleas Mantzios @ 2008-05-30 06:04 UTC (permalink / raw)
To: pgsql-admin; +Cc: kevin kempter <kevin@kevinkempterllc.com>
Στις 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgres, syslog and freeBSD
2008-05-30 04:35 postgres, syslog and freeBSD kevin kempter <kevin@kevinkempterllc.com>
2008-05-30 06:04 ` Re: postgres, syslog and freeBSD Achilleas Mantzios <achill@matrix.gatewaynet.com>
@ 2008-05-30 06:48 ` Medi Montaseri <montaseri@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Medi Montaseri @ 2008-05-30 06:48 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin@postgresql.org, "kevin kempter" <kevin@kevinkempterllc.com>
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 έγραψε:
> > 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgres, syslog and freeBSD
2008-05-30 04:35 postgres, syslog and freeBSD kevin kempter <kevin@kevinkempterllc.com>
@ 2008-05-30 07:38 ` CZUCZY Gergely <phoemix@harmless.hu>
4 siblings, 0 replies; 8+ messages in thread
From: CZUCZY Gergely @ 2008-05-30 07:38 UTC (permalink / raw)
To: kevin kempter <kevin@kevinkempterllc.com>; +Cc: 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
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgres, syslog and freeBSD
2008-05-30 04:35 postgres, syslog and freeBSD kevin kempter <kevin@kevinkempterllc.com>
@ 2008-05-30 08:05 ` Alexander Vysokovskih <av@ural.org>
4 siblings, 0 replies; 8+ messages in thread
From: Alexander Vysokovskih @ 2008-05-30 08:05 UTC (permalink / raw)
To: kevin kempter <kevin@kevinkempterllc.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgres, syslog and freeBSD
2008-05-30 04:35 postgres, syslog and freeBSD kevin kempter <kevin@kevinkempterllc.com>
@ 2008-05-30 08:39 ` Alexander Vysokovskih <av@ural.org>
4 siblings, 0 replies; 8+ messages in thread
From: Alexander Vysokovskih @ 2008-05-30 08:39 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2008-05-30 08:39 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-30 04:35 postgres, syslog and freeBSD kevin kempter <kevin@kevinkempterllc.com>
2008-05-30 04:57 ` Camilo Sperberg <unreal4u@chilehardware.com>
2008-05-30 05:01 ` Joshua D. Drake <jd@commandprompt.com>
2008-05-30 06:04 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-05-30 06:48 ` Medi Montaseri <montaseri@gmail.com>
2008-05-30 07:38 ` CZUCZY Gergely <phoemix@harmless.hu>
2008-05-30 08:05 ` Alexander Vysokovskih <av@ural.org>
2008-05-30 08:39 ` Alexander Vysokovskih <av@ural.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox