Search Postgresql Archives

Re: How to restore roles into new Database server?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to restore roles into new Database server?
From: Ninad Shah <nshah.postgres@xxxxxxxxx>
Date: Wed, 15 Sep 2021 19:40:32 +0530
Cc: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <DM6PR05MB6265D85B4ACDBE8E4D36BD5EF3DB9@DM6PR05MB6265.namprd05.prod.outlook.com>
References: <DM6PR05MB6265D85B4ACDBE8E4D36BD5EF3DB9@DM6PR05MB6265.namprd05.prod.outlook.com>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- RE: How to restore roles into new Database server?
  - From: Sridhar Parepalli

References:
- How to restore roles into new Database server?
  - From: Sridhar Parepalli

Prev by Date: How to restore roles into new Database server?
Next by Date: Re: How to restore roles into new Database server?
Previous by thread: How to restore roles into new Database server?
Next by thread: RE: How to restore roles into new Database server?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux