Re: Permissions pg_dump / import

Hi guys,

I'm doing a pg_dump and a pg_restore on the same command, using different
usernames and databases names.:

pg_dump --format=custom -v --no-password --no-owner --username=teste1
> --dbname=test1 --host=11.11.11.11 | pg_restore -v --schema=public
> --no-password --no-owner --username=master --host=11.11.11.12
> --dbname=new_test1

But I'm getting some permissions errors:

could not execute query: ERROR: role "devel" does not exist

To fix that, I ran on the server; also I'm using "*--no-owner*" and though
this kind of problem wouldn't be happening?

REVOKE ALL ON SCHEMA public FROM devel;

But it seems not working, as I'm still getting the errors.

Do you guys have any tips to solve this one?

Cheers

Patrick