RE: How to restore roles into new Database server?

[Sridhar Parepalli <Sridhar.Parepalli@xxxxxxx>]

Thank you! Ninad

 

 

From: Ninad Shah <nshah.postgres@xxxxxxxxx>
Sent: Wednesday, September 15, 2021 10:11 AM
To: Sridhar Parepalli <Sridhar.Parepalli@xxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxx> wrote:

Hello Pros,
Is there a quick way to create roles from database server to another db server?
Regards,
Sridhar Parepalli