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
triedon 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.klaver@aklaver.com
