| From: | Craig James <cjames(at)emolecules(dot)com> |
|---|---|
| To: | Kasia Tuszynska <ktuszynska(at)esri(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_restore |
| Date: | 2013-05-21 00:44:39 |
| Message-ID: | CAFwQ8rdkFABM592Wowe-5zgqe6zoq-Da5TMzXJ8woz0HW9ivrQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, May 20, 2013 at 3:57 PM, Kasia Tuszynska <ktuszynska(at)esri(dot)com>wrote:
> 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 ****
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dev Kumkar | 2013-05-21 00:45:44 | Re: ODBC constructs |
| Previous Message | Dev Kumkar | 2013-05-21 00:37:43 | Re: ODBC constructs |