Hi,
We desire to implement a multi-site server that unifies data from distant Postgres databases in a nightly batch. The distant databases have all the same architecture (schema). The size of data exchanged between distant servers and the multi-site manager has to be reduced to the strictly usefully data.
We naturally have been interested by the WAL archiving (PITR). But after a deep analysis of this skill, we still encounter problems. The main problem is unifying the data from many databases in a common database.
Has anyone experienced a solution to this problem... maybe not with WAL?
Thanks
Hugues