[ADMIN] WARNING: transaction log file "....." could not be archived: too many failures

2011-01-28 Thread Joby Joba
Hello. The following message appears continuously in the log file of postgresql : Jan 28 11:35:01 abcd postgres[28359]: [81-1] LOG: archive command "cp "pg_xlog/00010085" /u10/postgres/archive/"00010085"" failed: return Jan 28 11:35:01 abcd postgres[28359]: [81-2]

[ADMIN] pg_standby and compressed archive

2011-02-04 Thread Joby Joba
Hello ! in order to reduce disk space used by postgresql's archived logs I use the following command for the parameter archive_command : archive_command = 'gzip -c %p >/u10/pgmi/postgresql/archive/%f.gz' I have configured a standby database with the contrib module and pg_stanby. My question is

[ADMIN] Close jdbc connection

2011-06-09 Thread Joby Joba
Hello ! Is there a parameter usable to close connections after a timeout (like statement_timeout for the statements) ? Thanks Joby