Re: How to restore roles into new Database server?

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to restore roles into new Database server?
Date: 2021-09-15 14:55:17
Message-ID: 1ba11044-ed0f-8839-5655-c8ae734500cd@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond Brinzer 2021-09-15 15:29:07 Re: SQL queries as sets: was The tragedy of SQL
Previous Message Adrian Klaver 2021-09-15 14:25:04 Re: Basic Questions about PostgreSQL.