Re: [HACKERS] Urgent Help Required

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: [HACKERS] Urgent Help Required
Дата
Msg-id CAGrpgQ89OJpgYVTzUTZsQ5GCZNj9VW=JrYGbGnsgRJNFiX1xBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Urgent Help Required  (shailesh singh <shaileshjuly@gmail.com>)
Ответы Re: [HACKERS] Urgent Help Required
Список pgsql-general

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.

В списке pgsql-general по дате отправления:

Предыдущее
От: shailesh singh
Дата:
Сообщение: Re: Urgent Help Required
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Urgent Help Required