Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id F0B9F2E006A for ; Fri, 30 May 2008 01:57:27 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04477-04 for ; Fri, 30 May 2008 01:57:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.232]) by developer.postgresql.org (Postfix) with ESMTP id 2A4712E0077 for ; Fri, 30 May 2008 01:57:16 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so4486479rvf.43 for ; Thu, 29 May 2008 21:57:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; bh=8YII43vbGbIzfXcEci39Km+wHZOxg2URKPqOlDXcPDU=; b=wXON93oqqL2CAbVbNaMLAvW64Ldfzk21jMwxzjI7krZ8qWbpy3AhN1UDSOF929SiR7GlMYcaga9dh5vtswxlcNRGLwLQdmTVI5B6+Oq/aIE0ofcsd7MUcySGFtEO9Dyd6LTQFW7t/gpWMHQSc6VgBQuksNqUhgUDaXGBXR0fahk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=l0OSBfyWHrJp3iq2LOGcmI4kpQXA8K93U4oxn7zMEjgP1IJE/1K6ps9qIqkYu3O0Dt9MYmvIUZPUz5pLNh59C3HpHJZGUCP5XRt7Xl0oTlJ+b396+pqicXbXgkSEDKiw//HJDIRMm4k/fqDD6BC/nw5hF+J+k2zHljrSJDc2bDs= Received: by 10.141.170.10 with SMTP id x10mr2747352rvo.139.1212123434333; Thu, 29 May 2008 21:57:14 -0700 (PDT) Received: by 10.141.176.8 with HTTP; Thu, 29 May 2008 21:57:14 -0700 (PDT) Message-ID: Date: Fri, 30 May 2008 00:57:14 -0400 From: "Camilo Sperberg" To: "kevin kempter" Subject: Re: postgres, syslog and freeBSD Cc: pgsql-admin@postgresql.org In-Reply-To: <0AF6C4FA-FC04-4AC1-8603-7E5596301F62@kevinkempterllc.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7949_15081204.1212123434318" References: <0AF6C4FA-FC04-4AC1-8603-7E5596301F62@kevinkempterllc.com> X-Google-Sender-Auth: acc90ecaf8588360 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.981 tagged_above=0 required=5 tests=AWL=-0.981, HTML_MESSAGE=0.001, URIBL_BLACK=1.961 X-Spam-Level: X-Archive-Number: 200805/240 X-Sequence-Number: 29324 ------=_Part_7949_15081204.1212123434318 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Fri, May 30, 2008 at 12:35 AM, kevin kempter 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/ ------=_Part_7949_15081204.1212123434318 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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/ ------=_Part_7949_15081204.1212123434318--