Am 11.12.2017 um 17:48 schrieb marcelo:
The installation I'm planning will manage several databases, but not
all of them will change every day.
In order to planning/scripting the pg_dump usage, I would need to know
which databases had some change activity at the end of some day.
How can it be done?
TIA
I think you can use logical replication. Take a view at
https://github.com/eulerto/wal2json (for instance, there are other
solutions available), just capture the wal and check for changes for
every database.
it's just a rough idea...
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
