Re: Postgresql Database Corrupted

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Postgresql Database Corrupted
Дата
Msg-id dcc563d10710310807s1806a617x48472bf10f601dc1@mail.gmail.com
обсуждение исходный текст
Ответ на Postgresql Database Corrupted  (karthik keyan <karthik_arnold1@yahoo.com>)
Список pgsql-admin
On 10/30/07, karthik keyan <karthik_arnold1@yahoo.com> wrote:
> Hi admins
>
> I have a issue with my database .
>
> Its not starting up after /var got filled up
>
> After clearing some space still the database doesnt start up ..
>
> Pls find the log vacuumdb: vacuuming of database "insight_v1_0" failed:
> ERROR:  could not access status of transaction 124321809
> DETAIL:  could not read from file
> "/var/lib/pgsql/data/pg_clog/0076" at offset 147456:
> Success

So, how did you clear some space?  Did that involve deleting the file
listed above?  If not, you might be able to recreate the pg_clog/0076
file as a file filled with zeroes to get it back up, but who knows
what data you might be missing.

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

Предыдущее
От: yogesh
Дата:
Сообщение: PL/JAVA issues
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: how to check objects dependency??