Hi Adrian, > On 6 Feb 2025, at 19:44, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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
