Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group