Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.400.131.1.6\))
Subject: Re: libc to libicu via pg_dump/pg_restore?
From: Paul Foerster <paul.foerster@gmail.com>
In-Reply-To: <e89a7bb3-242d-4410-bd44-9cef059a5b3b@aklaver.com>
Date: Fri, 7 Feb 2025 07:35:36 +0100
Cc: Guillaume Lelarge <guillaume.lelarge@dalibo.com>,
 pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <F4491B66-EF79-43EC-B664-4E48050BC27D@gmail.com>
References: <B0DB872D-B2A0-4323-9EA8-A7FB4567ACCB@gmail.com>
 <2256966c-446f-4607-a47d-04b895b0747b@dalibo.com>
 <7A2A897E-AD8B-47F7-A29F-980D57425AD9@gmail.com>
 <f90acfff-8b6d-4ee3-814a-ebf44442ce04@dalibo.com>
 <12488E77-4D0F-46B1-B7C9-BFA1D61D6B62@gmail.com>
 <e89a7bb3-242d-4410-bd44-9cef059a5b3b@aklaver.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Archived-At: <https://www.postgresql.org/message-id/F4491B66-EF79-43EC-B664-4E48050BC27D%40gmail.com>
Precedence: bulk

Hi Adrian,

> On 6 Feb 2025, at 19:44, Adrian Klaver <adrian.klaver@aklaver.com> =
wrote:
>=20
> By ACL do you mean roles?
>=20
> If so roles are global to the cluster not the database, so I am not =
seeing -C being relevant.
>=20
> If not you will need to be more specific about what you are referring =
to.

I did a "pg_dumpall -r >roles.sql" on the originale database cluster and =
"psql -f roles.sql" on the new database cluster. So, roles are =
pre-created as is necessary.

No, I mean ACLs, like in "Access privileges" when doing a "\l".

Cheers,
Paul=