Re: Concatenate WAL contents - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Concatenate WAL contents
Date
Msg-id 20060515220426.GS26212@pervasive.com
Whole thread Raw
In response to Concatenate WAL contents  ("Houssais Hugues" <Hugues.Houssais@thomson.net>)
List 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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Exporting postgres query to CSV
Next
From: "Jim C. Nasby"
Date:
Subject: Re: understanding explain data