Обсуждение: Concatenate WAL contents
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 files using the address of backup files (aaa in xxxxx.aaa.backup files)?
On Wed, May 10, 2006 at 11:55:49AM +0200, Houssais Hugues wrote: > 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 files using the address of backup files (aaa in xxxxx.aaa.backup > files)? It's not possible to do multi-master WAL-based replication, because it describes table changes at a binary level. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
Thanks to Jim for replying us about WAL archiving! Indeed, WAL archiving has been abandoned for our needs. The content logged in WAL is more than only the modified data but the binary content of the modified table (or a part ofthe table). Then it is not possible to merge modifications on a common table from different databases. Because replicationsystem implies to increase database size, we decided to serialize the write database traffic in our code. Thenwe deserialize the traffic logs on the multisite database in a nightly cron. We suppose that the time to serialize/deserializeis not so important than the content exanged and the size of databases. Hugues -----Message d'origine----- De : Jim C. Nasby [mailto:jnasby@pervasive.com] Envoyé : mardi 16 mai 2006 00:04 À : Houssais Hugues Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] Concatenate WAL contents On Wed, May 10, 2006 at 11:55:49AM +0200, Houssais Hugues wrote: > 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 files using the address of backup files (aaa in xxxxx.aaa.backup > files)? It's not possible to do multi-master WAL-based replication, because it describes table changes at a binary level. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461