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 DM6PR05MB62654D584E0FCF871B050977F3DB9@DM6PR05MB6265.namprd05.prod.outlook.com
Whole thread Raw
In response to Re: How to restore roles into new Database server?  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
Tree view 
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 by date:

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