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

Re: postgres, syslog and freeBSD

From: CZUCZY Gergely <phoemix(at)harmless(dot)hu>
To: kevin kempter <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres, syslog and freeBSD
Date: 2008-05-30 07:38:51
Message-ID: 20080530093851.133c332e@twoflower.in.publishing.hu (view raw or flat)
Thread:
Lists: 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(at)kevinkempterllc(dot)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(dot)czuczy(at)harmless(dot)hu
Tel: +36-30-9702963

In response to

pgsql-admin by date

Next:From: Alexander VysokovskihDate: 2008-05-30 08:05:20
Subject: Re: postgres, syslog and freeBSD
Previous:From: Medi MontaseriDate: 2008-05-30 06:48:51
Subject: Re: postgres, syslog and freeBSD

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