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