Re: Best high availability solution ? - Mailing list pgsql-general

From Arnaud Lesauvage
Subject Re: Best high availability solution ?
Date
Msg-id 447D8A58.1010602@freesurf.fr
Whole thread Raw
In response to Re: Best high availability solution ?  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-general
Tino Wildenhain a écrit :
>> If I understand you right, you suggest that the wal files should be
>> automatically copied to the backup server, which should parse them as
>> soon as they arrive ?
>
> eactly.

Indeed, it seems to be the best solution !
After reading the backup-online page, I see that the recovery
process will end after at the end of the wal log. So with your
suggestion, I should script the copy of the wal files to the
backup server (say, every 5 minutes), and script on the backup
server a recovery process every 5 minutes also ?

--
Arnaud




pgsql-general by date:

Previous
From: "Philippe Lang"
Date:
Subject: Re: Problems posting messages in this mailing-list?
Next
From: "Philippe Lang"
Date:
Subject: PGSQL 7.4 -> 8.1 migration & performance problem