RE: How to restore roles into new Database server?

Поиск
Список
Период
Сортировка
От Sridhar Parepalli
Тема RE: How to restore roles into new Database server?
Дата
Msg-id DM6PR05MB62651FAC1ACB84B2B4FE1AB1F3DB9@DM6PR05MB6265.namprd05.prod.outlook.com
обсуждение исходный текст
Ответ на Re: How to restore roles into new Database server?  (Ninad Shah <nshah.postgres@gmail.com>)
Список pgsql-general
Дерево обсуждения

Thank you! Ninad

 

 

From: Ninad Shah <nshah.postgres@gmail.com>
Sent: Wednesday, September 15, 2021 10:11 AM
To: Sridhar Parepalli <Sridhar.Parepalli@sas.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: How to restore roles into new Database server?

 

EXTERNAL

This can be accomplished by taking a global dump. pg_dumpall utility has an option "-g" to accomplish that.

 

 

Regards,

Ninad Shah

 

On Wed, 15 Sept 2021 at 19:24, Sridhar Parepalli <Sridhar.Parepalli@sas.com> wrote:

Hello Pros,
Is there a quick way to create roles from database server to another db server?
Regards,
Sridhar Parepalli

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

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