From: Camilo Sperberg <unreal4u@chilehardware.com>
To: kevin kempter <kevin@kevinkempterllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgres, syslog and freeBSD
Date: Fri, 30 May 2008 00:57:14 -0400
Message-ID: <f05190a90805292157x7c23f1elb0e58458391350cf@mail.gmail.com> (raw)
In-Reply-To: <0AF6C4FA-FC04-4AC1-8603-7E5596301F62@kevinkempterllc.com>
References: <0AF6C4FA-FC04-4AC1-8603-7E5596301F62@kevinkempterllc.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: unreal4u@chilehardware.com, kevin@kevinkempterllc.com
Subject: Re: postgres, syslog and freeBSD
In-Reply-To: <f05190a90805292157x7c23f1elb0e58458391350cf@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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