On Tue, Oct 8, 2013 at 8:03 AM, shailesh singh <shaileshj...@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.
