Hi Adrian,
> On 6 Feb 2025, at 19:44, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> By ACL do you mean roles?
>
> If so roles are global to the cluster not the database, so I am not seeing -C being relevant.
>
> 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