Re: Best high availability solution ?

From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Best high availability solution ?
Date: 2006-05-31 12:21:44
Message-ID: 447D8A58.1010602@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Lang 2006-05-31 12:23:59 PGSQL 7.4 -> 8.1 migration & performance problem
Previous Message Philippe Lang 2006-05-31 12:13:57 Re: Problems posting messages in this mailing-list?