Skip site navigation (1) Skip section navigation (2)

Re: postgres, syslog and freeBSD

From: "Medi Montaseri" <montaseri(at)gmail(dot)com>
To: "Achilleas Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "kevin kempter" <kevin(at)kevinkempterllc(dot)com>
Subject: Re: postgres, syslog and freeBSD
Date: 2008-05-30 06:48:51
Message-ID: 8078a1730805292348m56aaf6dfg63c3157987554192@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
did you kill -hup syslogd after you changed syslog.conf

On Thu, May 29, 2008 at 11:04 PM, Achilleas Mantzios <
achill(at)matrix(dot)gatewaynet(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

In response to

pgsql-admin by date

Next:From: CZUCZY GergelyDate: 2008-05-30 07:38:51
Subject: Re: postgres, syslog and freeBSD
Previous:From: Achilleas MantziosDate: 2008-05-30 06:04:27
Subject: Re: postgres, syslog and freeBSD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group