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
