How to restore roles without changing postgres password

Поиск
Список
Период
Сортировка
От Andrus
Тема How to restore roles without changing postgres password
Дата
Msg-id 38D406CB287140A49F635258B634E072@dell2
обсуждение исходный текст
Ответы Re: How to restore roles without changing postgres password  (Justin <zzzzz.graf@gmail.com>)
Re: How to restore roles without changing postgres password  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi!

How to create backup script which restores all roles and role memberships 
from other server without changing postgres user password.

I tried shell script

PGHOST=example.com
PGUSER=postgres
PGPASSWORD=mypass
export PGHOST  PGPASSWORD  PGUSER
pg_dumpall --roles-only --file=globals.sql
psql -f globals.sql postgres

but this changes user postgres  password also.
How to restore roles so that postgres user password is not changed on 
restore.

Script runs on Debian 10 with Postgres 12
Server from where it reads users runs on Debian Squeeze with Postgres 9.1

Andrus 




В списке pgsql-general по дате отправления:

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Query returns no results until REINDEX
Следующее
От: Justin
Дата:
Сообщение: Re: How to restore roles without changing postgres password