Re: index "pg_authid_rolname_index" is not a btree

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index "pg_authid_rolname_index" is not a btree
Дата
Msg-id 25282.1250702431@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: index "pg_authid_rolname_index" is not a btree  ("Andrus Moor" <kobruleht2@hot.ee>)
Список pgsql-general
"Andrus Moor" <kobruleht2@hot.ee> writes:
> pg_amop in mydb contains 5 rows.
> pg_amop in  template1 database contains large number of rows.
> mydb does not contain user-defined operators.

> How to repair pg_amop in mydb ?

Well, you could try copying the physical file for pg_amop from template1
to mydb (and then reindexing it again).  I am not holding out a lot of
hope though.  I think you're most likely going to run into a dead end,
unfixable problem before you get any data out.

> Most of backup size contains few big tables which are not required to
> recover.

Maybe you should forget about pg_dump and just see if you can COPY
the tables you care about.

            regards, tom lane

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

Предыдущее
От: "Karsten Hilbert"
Дата:
Сообщение: Re: Unit conversion database (was: multiple paramters in aggregate function)
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Wich the best way to control the logic of a web application?