On Fri, 2006-05-05 at 04:21, Houssais Hugues wrote: > 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? Are you talking a big multi-way setup? That's rather complex, and resolution of conflicting updates can keep a DBA busy full time in a poorly thought out setup. OTOH, if you're looking at having one or more one-way pushes in your setup, you might want to look at using slony. There are a lot of ways you can set it up, depending on your needs. Got a bit more detail on what you're wanting to do?
