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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unique constraint on field inside composite type.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Permissions pg_dump / import