Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: How to restore roles into new Database server?
Date
Msg-id 1ba11044-ed0f-8839-5655-c8ae734500cd@gmx.net
Whole thread Raw
In response to How to restore roles into new Database server?  (Sridhar Parepalli <Sridhar.Parepalli@sas.com>)
Responses RE: How to restore roles into new Database server?  (Sridhar Parepalli <Sridhar.Parepalli@sas.com>)
List pgsql-general
Tree view 
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: Adrian Klaver
Date:
Subject: Re: Basic Questions about PostgreSQL.
Next
From: Raymond Brinzer
Date:
Subject: Re: SQL queries as sets: was The tragedy of SQL