Re: Permissions pg_dump / import
| От | Patrick B |
|---|---|
| Тема | Re: Permissions pg_dump / import |
| Дата | |
| Msg-id | CAJNY3iuYsLKzSmZXF9h+JE5jhPn2gWp-FvSWH+3+Rtr-dAi0Hw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Permissions pg_dump / import (Patrick B <patrickbakerbr@gmail.com>) |
| Ответы |
Re: Permissions pg_dump / import
|
| Список | pgsql-general |
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 по дате отправления: