Re: sanity error with pg_dump on postgresql 7.0.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: sanity error with pg_dump on postgresql 7.0.2
Дата
Msg-id 13326.1041953356@sss.pgh.pa.us
обсуждение исходный текст
Ответ на sanity error with pg_dump on postgresql 7.0.2  ("Dan Langille" <dan@langille.org>)
Ответы Re: sanity error with pg_dump on postgresql 7.0.2  ("Dan Langille" <dan@langille.org>)
Список pgsql-admin
"Dan Langille" <dan@langille.org> writes:
> I am forwarding this on behalf of bain@tcsn.co.za who is at a client
> site and cannot email.

> I did a search and found a mail stating that its possibly related to
> a deleted user having ownership of the table.
> "http://www.geocrawler.com/mail/msg.php3?msg_id=5653159&list=10" I
> checked and indeed the owner that created the table no longer exists.
> Unfortunately I have no idea who that user was.

You don't need to know.  Get the old owner's sysid with
    SELECT relowner FROM pg_class WHERE relname = 'busted_table';
then create a user with the appropriate sysid:
    CREATE USER foo WITH SYSID nnn;

Once you've done that, consider upgrading to a more recent Postgres.
It's been a good long while since pg_dump would choke on this situation.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum explained -> Dangerous ?
Следующее
От: "Gareth Kirwan"
Дата:
Сообщение: Postgresql 7.3 and startup