Postgres Pro
Downloads
Home   >   mailing lists

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

From Ninad Shah
Subject Re: How to restore roles into new Database server?
Date
Msg-id CAOFEiBcYzhrJe48D7d2FseQRvXEm9rEPkZVUZo_W2D-kZXKfGg@mail.gmail.com
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
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: Sridhar Parepalli
Date:
Subject: How to restore roles into new Database server?
Next
From: Adrian Klaver
Date:
Subject: Re: How to restore roles into new Database server?