Postgres Pro
Downloads
Home   >   mailing lists

Re: Permissions pg_dump / import - Mailing list pgsql-general

From Patrick B
Subject Re: Permissions pg_dump / import
Date
Msg-id CAJNY3iuYsLKzSmZXF9h+JE5jhPn2gWp-FvSWH+3+Rtr-dAi0Hw@mail.gmail.com
Whole thread Raw
In response to Re: Permissions pg_dump / import  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Permissions pg_dump / import  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unique constraint on field inside composite type.
Next
From: Tom Lane
Date:
Subject: Re: Permissions pg_dump / import