How to restore roles into new Database server?
Hello Pros, Is there a quick way to create roles from database server to another db server? Regards, Sridhar Parepalli
RE: How to restore roles into new Database server?
Thank you! Ninad From: Ninad Shah Sent: Wednesday, September 15, 2021 10:11 AM To: Sridhar Parepalli 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 mailto:sridhar.parepa...@sas.com>> wrote: Hello Pros, Is there a quick way to create roles from database server to another db server? Regards, Sridhar Parepalli
RE: How to restore roles into new Database server?
Thank you, Adrian! -Original Message- From: Adrian Klaver Sent: Wednesday, September 15, 2021 10:13 AM To: Sridhar Parepalli ; pgsql-general@lists.postgresql.org Subject: Re: How to restore roles into new Database server? EXTERNAL On 9/15/21 6:53 AM, Sridhar Parepalli wrote: > Hello Pros, > Is there a quick way to create roles from database server to another db > server? pg_dumpall -g the_database -f globals.sql psql -d other_database -f globals.sql Though this will include other global objects e.g. tablespaces. See: https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent%2Fapp-pg-dumpall.html&data=04%7C01%7CSridhar.Parepalli%40sas.com%7C33d6e5184b134c1fa0ee08d97852e376%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C637673120233711031%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=AYl6WE8Dc%2B0ZiBtFnVuaPrF%2BdMQRUHthdMsoQgJ5KgI%3D&reserved=0 > Regards, > Sridhar Parepalli > > -- Adrian Klaver adrian.kla...@aklaver.com
RE: How to restore roles into new Database server?
Thank you, Thomas! -Original Message- From: Thomas Kellerer 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
