Re: [ADMIN] postgres, syslog and freeBSD

2008-05-30 Thread 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

Re: [ADMIN] postgres, syslog and freeBSD

2008-05-30 Thread 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

Re: [ADMIN] postgres, syslog and freeBSD

2008-05-30 Thread CZUCZY Gergely
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 <[EMAIL PROTECTED]> wrote: > Hi list; > > I'm trying to get postgres

Re: [ADMIN] postgres, syslog and freeBSD

2008-05-29 Thread Medi Montaseri
did you kill -hup syslogd after you changed syslog.conf On Thu, May 29, 2008 at 11:04 PM, Achilleas Mantzios < [EMAIL PROTECTED]> 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

Re: [ADMIN] postgres, syslog and freeBSD

2008-05-29 Thread Achilleas Mantzios
Στις 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'

Re: [ADMIN] postgres, syslog and freeBSD

2008-05-29 Thread Joshua D. Drake
Camilo Sperberg wrote: On Fri, May 30, 2008 at 12:35 AM, kevin kempter <[EMAIL PROTECTED] > wrote: -- Sent via pgsql-admin mailing list ([email protected] ) To make changes to your subscription: http://w

Re: [ADMIN] postgres, syslog and freeBSD

2008-05-29 Thread Camilo Sperberg
On Fri, May 30, 2008 at 12:35 AM, kevin kempter <[EMAIL PROTECTED]> 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_facilit

[ADMIN] postgres, syslog and freeBSD

2008-05-29 Thread 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