Re: pg_restore and permissions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_restore and permissions
Дата
Msg-id 4757.1019761086@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_restore and permissions  (Florian Weimer <Weimer@CERT.Uni-Stuttgart.DE>)
Ответы Re: pg_restore and permissions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
Florian Weimer <Weimer@CERT.Uni-Stuttgart.DE> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> SET SESSION AUTHORIZATION should have been used instead, but I doubt
>> Florian has any convenient way to re-do the dump file with that option.

> Fortunately, I can re-do the dump (I'm eager to become a professional
> with a production and a testing machine ;-).

Oh, in that case you can use
    pg_dump -X use-set-session-authorization

> But SET SESSION AUTHORIZATION does not seem to be available in 7.2.1,
> yet 7.1.3.

I do not think 7.1's pg_dump had this option, but you can run 7.2's
pg_dump against the 7.1 server (in fact that is probably preferable
anyhow).

I would like to see use-set-session-authorization become the default
before 7.3 release, but haven't got around to doing anything about it.

            regards, tom lane

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

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: pg_restore and permissions
Следующее
От: Michael Glenn
Дата:
Сообщение: Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database