Re: [PERFORM] PG Logging is Slow

2004-12-20 Thread Theo Galanakis
Title: RE: [PERFORM] PG Logging is Slow Thankyou Alexander,     That has worked and appears to have fixed the issue with syslog. Theo -Original Message- From: Alexander Borkowski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 21 December 2004 10:09 AM To: Theo Galanakis Cc

Re: [PERFORM] PG Logging is Slow

2004-12-20 Thread Theo Galanakis
we use redhad linux and syslog, I'm no sys-admin, so I'm not sure if there is a difference between syslogd and syslog. Theo -Original Message- From: Grega Bremec [mailto:[EMAIL PROTECTED]] Sent: Monday, 20 December 2004 3:49 PM To: Theo Galanakis Cc: [EMAIL PROTECTED] S

[PERFORM] PG Logging is Slow

2004-12-19 Thread Theo Galanakis
Title: Message Under postgres 7.3 logging is incredibly slow! I have applied the following settings: syslog = 2 syslog_facility = 'LOCAL0' syslog_ident = 'postgres'    log_connections =  true log_duration =  true log_pid =  true log_statement =  true log_timestamp =  true    This severely im

[PERFORM] indentifying the database in a Postgres log file.

2004-12-15 Thread Theo Galanakis
Title: indentifying the database in a Postgres log file. I have written a program that parses a syslog file, reading all the postgres transactions. I would like to know if there is a way for postgres to log also the specific database the sql statement originated from. The only options availa