Re: Constant WAL replay

Joshua D. Drake wrote:
> Alvaro Herrera wrote:
>
>> On Sun, Apr 24, 2005 at 08:10:34AM +0200, Hans-Jürgen Schönig wrote:
>>
>>
>>> The idea: We are looking for a way to implement a synchronous
>>> single-master / multiple slaves systems.
>>> Meanwhile we are able to serialize / deserialize WAL records and send
>>> them to a group communication system which transports those records
>>> to the slave database.
>>> This is not hard to do.
>>
>>
>>
>> In fact, I believe Command Prompt's Mammoth Replicator does exactly
>> this.
>
>
> Very close. We don't use the WAL (yet, slated for probably 8.1) but we
> do use a transaction log shipping method. So the implementation is
> almost the same.
>
> Sincerely,
>
> Joshua D. Drake
> Command Prompt, Inc.

Joshua,

This sounds interesting. If you don't use the WAL but a transaction log
shipping - what does it mean in terms of PostgreSQL? Do you create your
own transaction log?
What really interests me here: Where is you code located in order to
make sure that this things can work reliably?

Best regards,

Hans

--
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/664/393 39 74
www.cybertec.at, www.postgresql.at