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.
