| From: | Paul Foerster <paul(dot)foerster(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Guillaume Lelarge <guillaume(dot)lelarge(at)dalibo(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: libc to libicu via pg_dump/pg_restore? |
| Date: | 2025-02-07 06:35:36 |
| Message-ID: | F4491B66-EF79-43EC-B664-4E48050BC27D@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Adrian,
> On 6 Feb 2025, at 19:44, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michał Kłeczek | 2025-02-07 08:22:13 | Re: Lookup tables |
| Previous Message | Paul Foerster | 2025-02-07 06:32:28 | Re: libc to libicu via pg_dump/pg_restore? |