Re: could not read block... how could I identify/fix

Поиск
Список
Период
Сортировка
От Naoko Reeves
Тема Re: could not read block... how could I identify/fix
Дата
Msg-id CAGoos16tusr9v_EaCbEeD8LAERSX=NjtLqbgCrx4XTkF+DmgRA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: could not read block... how could I identify/fix  (Vick Khera <vivek@khera.org>)
Ответы Re: could not read block... how could I identify/fix  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Дерево обсуждения
Vick,
Thank you very much. Yes, I just go ahead did what you said and all appears to be fine.


On Thu, Mar 29, 2012 at 7:08 AM, Vick Khera <vivek@khera.org> wrote:
On Wed, Mar 28, 2012 at 6:31 PM, Naoko Reeves <naokoreeves@gmail.com> wrote:
> Do you think this should be the next step I might take?
> Could you give me an advice of how I could identify corrupted error.

It seems to me that since you can successfully dump the table (I
assume you validated the data was all there somehow), you should go
ahead and dump your whole DB, delete the current one, create it again,
then restore it from scratch.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Naoko Reeves

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

Предыдущее
От: Bret Stern
Дата:
Сообщение: Re: Move Tables From One Database to Another
Следующее
От: leaf_yxj
Дата:
Сообщение: Re: system catalog privilege and create privilege ??? how to control them?? thanks