Re: Permissions pg_dump / import

Patrick B <patrickbakerbr@gmail.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