| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
| Cc: | Ilya Kazakevich <Ilya(dot)Kazakevich(at)jetbrains(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Permissions pg_dump / import |
| Date: | 2016-08-23 01:41:14 |
| Message-ID: | 17544.1471916474@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Patrick B <patrickbakerbr(at)gmail(dot)com> writes:
> I'm doing a pg_dump and a pg_restore on the same command, using different
> usernames and databases names.:
> ...
> But I'm getting some permissions errors:
> could not execute query: ERROR: role "devel" does not exist
If that's from
> REVOKE ALL ON SCHEMA public FROM devel;
it's not a permissions error, it's complaining there's no such role
to grant/revoke from in the destination DB. You may want to use
--no-privileges along with --no-owner if the destination doesn't
have the same set of users as the source. Or just ignore these errors.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-08-23 02:55:17 | Re: Unique constraint on field inside composite type. |
| Previous Message | Patrick B | 2016-08-23 01:32:02 | Re: Permissions pg_dump / import |