Re: recover corrupt DB?

Поиск
Список
Период
Сортировка
От Dan Armbrust
Тема Re: recover corrupt DB?
Дата
Msg-id 82f04dc40905040651h1c4bbacct72147c3e0f764e73@mail.gmail.com
обсуждение исходный текст
Ответ на Re: recover corrupt DB?  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: recover corrupt DB?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
> These reports seem to come up a bit, with disk full issues resulting in
> the need to pg_resetxlog, dump, and re-initdb, but I wouldn't be too
> shocked if they all turned out to be on xfs or something like that.
>

My particular disk-full condition was on ext2.  Nothing exotic.  Also,
the process that filled the disk was postgres - if that makes any
difference - I had left a debug level turned up in the postgres config
file, and it was logging every single db query.  Since it wasn't set
up to remove old log files - it filled the disk.

Nothing else unusual occurred that I'm aware of - things went weird
for the lab tester, he cleared some space, rebooted the system, and
postgres didn't come back online.

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

Предыдущее
От: "Markus Wollny"
Дата:
Сообщение: Re: diff-/patch-functionality for text-type data insidePostgreSQL
Следующее
От: Torsten Zühlsdorff
Дата:
Сообщение: How to return SETOF RECORD?