| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Paul Foerster <paul(dot)foerster(at)gmail(dot)com> |
| Cc: | pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: libc to libicu via pg_dump/pg_restore? |
| Date: | 2025-02-13 21:30:43 |
| Message-ID: | 3e25830f-cc92-4d4c-b6bf-c3496835c84e@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2/13/25 11:57, Paul Foerster wrote:
> Hi Adrian,
>
> I'm not at work anymore and won't be until Monday (long weekend 🤣). So I don't have the exact case handy. However, I tried on my home database clusters (15.10 and 17.3). Seems, at least here at home, only using -C works. I don't know (yet) why it does not work at work.
>
> Here's what I tried on my own clusters. Note the access privileges for "paul".
>
>
> So, "paul" again has CTc after pg_restore. That's what does not work at work. I'll have to figure out what's wrong there.
1) Verify the GRANT is in the dump file.
2) Check the Postgres log manually to see if there is an error that is
causing the GRANT to be skipped.
>
> Cheers,
> Paul
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcelo Fernandes | 2025-02-13 22:59:50 | Re: Best Approach for Swapping a Table with its Copy |
| Previous Message | Paul Foerster | 2025-02-13 19:57:00 | Re: libc to libicu via pg_dump/pg_restore? |