I make a database backup using a command like (
-Fd meaning "directory" format):
pg_dump -U postgres -Fd -j 8 -f testdb.dir testdb
My DB contains many schemas with personal data. At some point I might need to remove one schema from the backup. Restore&re-dump is not a feasible solution (too many backups).
So ideally I would need a command like
command --remove-schema=user123 testdb.dir. That would just remove an appropriate
1234.dat.gz file and perhaps update
PS: I know I can list contents with
pg_restore -l, but haven't found docs describing format of the output file. I don't want to guess what is what and risk data loss.