We have some large staging/scratch tables in one of our PostgreSQL databases. The data in them can be automatically regenerated from other databases after recovery of the database, and aren't business critical. Is there a way to ignore those tables when backing up using Barman? They are all in one schema.
This is to reduce recovery time and save space.
Maybe we can use some sort of persistent temporary tables? Tablespaces?
We have the tables because it is convenient when we do ETL. But aren't used by any applications or clients.
Are there other alternatives to do something similar?
Some documentation I've been reading through: