On Tue, Oct 08, 2013 at 08:06:50AM -0700, bricklen wrote: > 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.
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 <klep...@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
signature.asc
Description: Digital signature
