Re: pg_restore ERROR: permission denied to change default privileges

13 Jun 2025, 20:13 by adrian.klaver@aklaver.com:

>
> To get at an editable script you can do something like:
>
> pg_restore -f my_database_txt.sql  my_database.dump
>
> This will give you a plain text version of the dump that you can feed back to psql to load into remote database.
>

Thanks Adrian !

I had thought maybe maybe I could do a "pg_restore -l my_database.dump" and ignore the relevant line using whatever the
otherflag is, but sadly there doesn't appear to be enough flexibility, i.e.  

pg_restore -l my_database.dump | fgrep -F postgres
gives:
2067; 826 16607 DEFAULT ACL public DEFAULT PRIVILEGES FOR TABLES postgres

But

pg_restore -l my_database.dump | fgrep -F my_database_ro
gives nothing.   :(

So either your solution or Tom's "just ignore it" sound like they'll work.