I have a PostgreSQL server that contains a number of databases. The number varies over time between 20 to 30.
Some of these databases contain real production information for what we want to have the best protection possible. So I activated PITR (wal log backup) for them.
But some others are just containing immutable information or information that can be reconstructed with not so much cost. For these ones we don't want to have backups at all or something like one pg_dump a day must be enough.
The issue I have is that after activating PITR Postgres is saving the logs for all the databases. And some of the second category DB's have really big modification rate, leading to huge space taken by logs.
I will like to have PITR active for only some tablespaces (for example). This will allow me to place the DBs in the right tablespace for having the level of protection that we need.
But I have been unable to find a way to achieve that.
Any experience on that setup?