Re: [GENERAL] Concatenate WAL contents

2006-05-17 Thread Houssais Hugues
not so important than the content exanged and the size of databases. Hugues -Message d'origine- De : Jim C. Nasby [mailto:[EMAIL PROTECTED] Envoyé : mardi 16 mai 2006 00:04 À : Houssais Hugues Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] Concatenate WAL contents On Wed

[GENERAL] Concatenate WAL contents

2006-05-12 Thread Houssais Hugues
Hi, In order to unify many distant Postgres databases, we decided to use WAL archiving. The idea is to concatenate a distant WAL archive at the beginning of a local WAL archive before launching PITR restore. Does anyone know how to concatenate WAL contents, i.e. decode and encode WAL file

Re: [GENERAL] Unify distant Postgres databases

2006-05-09 Thread Houssais Hugues
rtial databases to one global database. But maybe I'm wrong... Can you tell me more about this use of Slony? Hugues -Message d'origine- De : Scott Marlowe [mailto:[EMAIL PROTECTED] Envoyé : vendredi 5 mai 2006 19:10 À : Houssais Hugues Cc : pgsql general Objet : Re: [GENERAL

[GENERAL] Unify distant Postgres databases

2006-05-05 Thread Houssais Hugues
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 strictl