| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Houssais Hugues <Hugues(dot)Houssais(at)thomson(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Concatenate WAL contents |
| Date: | 2006-05-15 22:04:26 |
| Message-ID: | 20060515220426.GS26212@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brendan Duddridge | 2006-05-15 22:05:46 | Re: can't reindex a couple of tables |
| Previous Message | Jim C. Nasby | 2006-05-15 21:41:41 | Re: Exporting postgres query to CSV |