Patrick B <patrickbakerbr@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
