| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | shailesh singh <shaileshjuly(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Urgent Help Required |
| Date: | 2013-10-08 15:06:50 |
| Message-ID: | CAGrpgQ89OJpgYVTzUTZsQ5GCZNj9VW=JrYGbGnsgRJNFiX1xBA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Tue, Oct 8, 2013 at 8:03 AM, shailesh singh <shaileshjuly(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-10-08 15:09:10 | Re: Urgent Help Required |
| Previous Message | shailesh singh | 2013-10-08 15:03:26 | Re: [GENERAL] Urgent Help Required |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-10-08 15:09:10 | Re: Urgent Help Required |
| Previous Message | shailesh singh | 2013-10-08 15:03:26 | Re: [GENERAL] Urgent Help Required |