Re: pg_restore
| От | Craig James |
|---|---|
| Тема | Re: pg_restore |
| Дата | |
| Msg-id | CAFwQ8rdkFABM592Wowe-5zgqe6zoq-Da5TMzXJ8woz0HW9ivrQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | pg_restore (Kasia Tuszynska <ktuszynska@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.
I recently restored a database using 9.2.1 that has a number of schemas, each with a separate owner, and had no problems at all.
Craig
Anyone else noticed or had issues with this?
Sincerely,
Kasia
В списке pgsql-admin по дате отправления: