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: Thomas Kellerer <shammat@xxxxxxx>
Date: Wed, 15 Sep 2021 16:55:17 +0200
In-reply-to: <DM6PR05MB6265D85B4ACDBE8E4D36BD5EF3DB9@DM6PR05MB6265.namprd05.prod.outlook.com>
References: <DM6PR05MB6265D85B4ACDBE8E4D36BD5EF3DB9@DM6PR05MB6265.namprd05.prod.outlook.com>
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666

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

[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: Re: Basic Questions about PostgreSQL.
Next by Date: Re: SQL queries as sets: was The tragedy of SQL
Previous by thread: RE: 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