Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 297F392B8E6 for ; Thu, 5 Jul 2012 13:03:36 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SmoWk-0006oa-Fg for pgsql-admin@postgresql.org; Thu, 05 Jul 2012 16:03:35 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q65G3L5f026923; Thu, 5 Jul 2012 12:03:21 -0400 (EDT) From: Tom Lane To: isabella.ghiurea@nrc-cnrc.gc.ca cc: "pgsql-admin@postgresql.org" Subject: Re: auto vacuum errors In-reply-to: <4FF5AAEB.6040103@nrc-cnrc.gc.ca> References: <4FF499F0.9030601@nrc-cnrc.gc.ca> <9816.1341461883@sss.pgh.pa.us> <4FF5AAEB.6040103@nrc-cnrc.gc.ca> Comments: In-reply-to Isabella Ghiurea message dated "Thu, 05 Jul 2012 07:55:39 -0700" Date: Thu, 05 Jul 2012 12:03:21 -0400 Message-ID: <26922.1341504201@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/23 X-Sequence-Number: 39740 Isabella Ghiurea writes: > Here is my error , the missing files were removed by mistake , I have > another similar db cfg with this tables:spherrtmp% and no issues. > I 'm thinking to restore this tables content from this second db , > will this eliminate the auto vacuum error ? What you ought to do is drop the tables that are reported as causing the error. Or the whole database --- are you actually doing something useful in contrib_regression, or is that just left over from testing? regards, tom lane