Re: [HACKERS] Urgent Help Required

On Tue, Oct 08, 2013 at 08:06:50AM -0700, bricklen wrote:
> On Tue, Oct 8, 2013 at 8:03 AM, shailesh singh <shaileshjuly@gmail.com>wrote:
>
> > HINT: To avoid a database shutdown, execute a full-database VACUUM in
> > "patnadbold".
> > ERROR: could not access status of transaction 33011
> > DETAIL: could not open file "pg_clog/0000": No such file or directory
> > exit
> >
> >
> > After this i am able to stop /start my db server but i am not able to
> > connect to my databases (it tells to run vacuum full first on patnadbold
> > databases)
> >
>
> The message does *not* say to run "VACUUM FULL", it says to run a
> "full-database VACUUM". Different things.
> Connect to "patnadbold" and issue "VACUUM;" (without double-quotes) as the
> others have suggested.

In case it isn't clear to the original poster, VACUUM FULL will take a
lot longer than a simple VACUUM and probably not really help much.

Just plain VACUUM.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
   -- Arthur Schopenhauer