RE: How to restore roles into new Database server?

Поиск
Список
Период
Сортировка
От Sridhar Parepalli
Тема RE: How to restore roles into new Database server?
Дата
Msg-id DM6PR05MB62654D584E0FCF871B050977F3DB9@DM6PR05MB6265.namprd05.prod.outlook.com
обсуждение исходный текст
Ответ на Re: How to restore roles into new Database server?  (Thomas Kellerer <shammat@gmx.net>)
Список pgsql-general
Дерево обсуждения 
Thank you, Thomas!

-----Original Message-----
From: Thomas Kellerer <shammat@gmx.net> 
Sent: Wednesday, September 15, 2021 10:55 AM
To: pgsql-general@lists.postgresql.org
Subject: Re: How to restore roles into new Database server?

EXTERNAL

Sridhar Parepalli schrieb am 15.09.2021 um 15:53:
> Hello Pros,
> Is there a quick way to create roles from database server to another db server?

You can use pg_dumpall with the --globals-only parameter to create a SQL script that contains all roles from the source
server

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

Предыдущее
От: Sridhar Parepalli
Дата:
Сообщение: RE: How to restore roles into new Database server?
Следующее
От: Michael Nolan
Дата:
Сообщение: Re: Alter and move corresponding: was The tragedy of SQL