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
