Обсуждение: 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

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

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