13 Jun 2025, 20:13 by adrian.klaver@xxxxxxxxxxx: > > 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 other flag 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.
