It would be useful to have daily backups in .dump format to enable loading of only a specific schema.
Current workaround:
We have spent most of the day trying to iterate through a .sql file trying to remove the data schema and nothing has worked. We ended up restoring the entire .sql file to a temporary database, dropping the data schema, creating a new dump with pg_restore...--format=custom and using that to restore to our dev database.
Created by Matt Maddex
·