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

From Tino Wildenhain
Subject Re: Best high availability solution ?
Date
Msg-id 447D74F8.4080601@wildenhain.de
Whole thread Raw
In response to Re: Best high availability solution ?  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: Best high availability solution ?
List pgsql-general
Arnaud Lesauvage schrieb:
> Tino Wildenhain a écrit :
>
>> pg_dump does not require you to stop the master database anyway.
>> (in fact it cannot even dump a stopped database :-)
>
>
> Hello Tino,
>
> I think I might just use this pg_dump solution...
> Seems to be quite simple to set up.

personally I think the WAL approach is by far easier
to set up and maintain - the pg_dump is in fact easy,
but the restore to another database can be tricky
if you want it unattended and bullit-proof the same
time.

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Best high availability solution ?
Next
From: Arnaud Lesauvage
Date:
Subject: Re: Best high availability solution ?