Re: [ADMIN] Autovacuum seems to block database: WARNING worker took too long to start

2010-11-16 Thread Pablo Delgado Díaz-Pache
reason? If it's another reason ... what could it be? thanks in advance for your help 2010/11/16 Alvaro Herrera alvhe...@commandprompt.com Excerpts from Pablo Delgado Díaz-Pache's message of lun nov 15 04:52:53 -0300 2010: But it strikes me that the code comment is wrong in one significant

[ADMIN] Autovacuum seems to block database: WARNING worker took too long to start

2010-11-15 Thread Pablo Delgado
Hi all, I'm having a strange problem with postgres autovacuum Everything is working fine until I start getting the following errors ... and postgres stops working shortly after (it stops accepting connections) 2010-11-13 12:34:08.599 CET|1|||7104||4cde77b0.1bc0|2010-11-13 12:34:08

[ADMIN] Postgres error: could not open relation base/xxxxx/yyyyy

2010-11-15 Thread Pablo Delgado Díaz-Pache
Hi all, We've been using postgres for 9 years without a problem until now! Two problems in a very short time! The first one is described in http://postgresql.1045698.n5.nabble.com/Autovacuum-seems-to-block-database-WARNING-worker-took-too-long-to-start-td3264261.html This is another one (not

Re: [ADMIN] Postgres error: could not open relation base/xxxxx/yyyyy

2010-11-15 Thread Pablo Delgado Díaz-Pache
backups to do any database replay (or similar) work which would lead to a viable situation. Στις Monday 15 November 2010 11:55:38 ο/η Pablo Delgado Díaz-Pache έγραψε: Hi all, We've been using postgres for 9 years without a problem until now! Two problems in a very short time! The first one

[ADMIN] Autovacuum seems to block database: WARNING worker took too long to start

2010-11-14 Thread Pablo Delgado Díaz-Pache
Hi all, I'm having a strange problem with postgres autovacuum Everything is working fine until I start getting the following errors ... and postgres stops working shortly after (it stops accepting connections) 2010-11-13 12:34:08.599 CET|1|||7104||4cde77b0.1bc0|2010-11-13 12:34:08

Re: [ADMIN] Autovacuum seems to block database: WARNING worker took too long to start

2010-11-14 Thread Pablo Delgado Díaz-Pache
Hi Tom, thanks for your detailed responses. I really appreciate it. My comments below inline ... I'm having a strange problem with postgres autovacuum Everything is working fine until I start getting the following errors ... and postgres stops working shortly after (it stops accepting