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