pg_restore

Поиск
Список
Период
Сортировка
От Kasia Tuszynska
Тема pg_restore
Дата
Msg-id 6C308A1FFB24664F8636F3B58ABEF8451D8FFEF1@RED-INF-EXMB-P2.esri.com
обсуждение исходный текст
Ответы Re: pg_restore
Список pgsql-admin

Hi Everybody,

Has anyone ran into issues running pg_restore?

It seems that between 8.3.8 and 9.0.5, 9.1.3 the behavior of pg_restore has changed.

 

Previously I was able to have several data owners with their own schemas and running a pg_restore as one superuser was able to restore the objects in those schemas without an issue.

 

At 9.0.5, I found that I had to restore each schema of a data owner separately.

At 9.1.3,  I found that in addition to that I need to make each of those data owners superusers.

 

I am fully aware that the dev work for core replication was occurring at this time, but I have been unable to find any documentation about the potential changes to the basic pg_restore functionality.

 

Anyone else noticed or had issues with this?

 

Sincerely,

Kasia

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

Предыдущее
От: Armand du Plessis
Дата:
Сообщение: pg_buffer_cache - dependencies
Следующее
От: Craig James
Дата:
Сообщение: Re: pg_restore