Re: Fwd: Errors on pg_dumpall

Поиск
Список
Период
Сортировка
От Lukasz Brodziak
Тема Re: Fwd: Errors on pg_dumpall
Дата
Msg-id CAGWYGjXhn4SKAhx1cPhjU9qiaSoee0C6BCcw4SsJ41k0B5aypw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: Errors on pg_dumpall  (Craig Ringer <ringerc@ringerc.id.au>)
Ответы Re: Fwd: Errors on pg_dumpall
Список pgsql-admin
2012/11/3 Craig Ringer <ringerc@ringerc.id.au>:
> On 11/01/2012 10:05 PM, Terry Khatri wrote:
>
> Somebody PLEASE HELP ! is Tome Lane around !
>
>
> http://www.postgresql.org/support/professional_support/

Hi,

Run the following SELECT on the database: select oid,* from
pg_namespace this will bring up all the schemas in the db along with
the OIDs. Check what schema name is under the OID given in error then
try to delete all the referrences to this schema name from db and run
pg_dumpall again.
Of course before doing so stop the PostgreSQL server and make a copy
of the data folder just in case.

Regards

--
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: autovacuum with lots of open file references to deleted files
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: Autoanalyze of the autovacuum daemon ...