Re: auto vacuum errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: auto vacuum errors
Date: 2012-07-05 16:03:21
Message-ID: 26922.1341504201@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Akash 2012-07-06 05:06:13 Re: Delay in completion of aggregation inserts when run in a single commit - PG 9.1.2
Previous Message Isabella Ghiurea 2012-07-05 14:55:39 Re: auto vacuum errors