Re: [ADMIN] postgres, syslog and freeBSD

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

Στις 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

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

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

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

[ADMIN] String comparison problem.

Dear All, I have some problem with string comparison. I use postgresql 8.3.1,UTF8 encoding, on CentOS 5.5. Why dose the result of SQL statement : "select '1.1' < '101';" is false but "select '1.1'::bytea < '101'::bytea;" is ture? mis=# select '.' < '0'; ?column? -- t (

[ADMIN] statistics collector Log message

When starting up a second instance of postgres on a server, received: LOG: could not bind socket for statistics collector: Cannot assign requested address LOG: trying another address for the statistics collector Is this something to be concerned with, or expected behavior? Karen Ston