Re: I/O error on data file, can't run backup

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: I/O error on data file, can't run backup
Дата
Msg-id 26013.1317847309@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: I/O error on data file, can't run backup  (Leif Biberg Kristensen <leif@solumslekt.org>)
Ответы Re: I/O error on data file, can't run backup
Список pgsql-general
Leif Biberg Kristensen <leif@solumslekt.org> writes:
> I seemingly fixed the problem by stopping postgres and doing:
> balapapa 612249 # mv 11658 11658.old
> balapapa 612249 # mv 11658.old 11658

> And the backup magically works.

Wow, that is magic.  I was going to suggest copying pg_opfamily from
template0, which would probably work (maybe requiring reindexing) as
long as you didn't have any non-core data types in use.  But you
got lucky.

> I'm gonna move the data to another disk right now.

Good plan.

            regards, tom lane

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

Предыдущее
От: Henry Drexler
Дата:
Сообщение: Re: Analytic type functionality, matching patters in a column then increment an integer
Следующее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: I/O error on data file, can't run backup