Postgres Pro
Downloads
Home   >   mailing lists

RE: How to restore roles into new Database server? - Mailing list pgsql-general

From Sridhar Parepalli
Subject RE: How to restore roles into new Database server?
Date
Msg-id DM6PR05MB62651FAC1ACB84B2B4FE1AB1F3DB9@DM6PR05MB6265.namprd05.prod.outlook.com
Whole thread Raw
In response to Re: How to restore roles into new Database server?  (Ninad Shah <nshah.postgres@gmail.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: Steve Litt
Date:
Subject: Alter and move corresponding: was The tragedy of SQL
Next
From: Sridhar Parepalli
Date:
Subject: RE: How to restore roles into new Database server?