Re: High availability with Postgres - Mailing list pgsql-admin

From Greg Spiegelberg
Subject Re: High availability with Postgres
Date
Msg-id AANLkTikqANXECUJZZ5NgPSN-zq9QeK-s4FU42f436JeB@mail.gmail.com
Whole thread Raw
In response to High availability with Postgres  (Elior Soliman <elior.soliman@correlix.com>)
List pgsql-admin
On Sun, Jun 20, 2010 at 10:36 AM, Elior Soliman
<elior.soliman@correlix.com> wrote:
> Hello,
>
> My company looking for some solution for High availability with Postgres.
>
> Our optional solution is as follows :
> Two DB servers will be using a common external storage (with raid). Both
> servers are going to use the same DB files on the storage (as
> active/passive)
>
> Now I'm trying to understand how Postgres can work with this configuration.
> I.e :
>
> DB_server1 crashed, so we want to start DB_server2 using same files.
> Is it possible ?

I've used the Symantec Storage Foundation & Cluster Server products in
the past.  Worked very well in shared SAN storage, 4-way cluster with
3 service groups each running PostgreSQL.  Easy to configure and
manage too.  Their volume manager and file system are very mature and
always recovered well.

HTH.

Greg

pgsql-admin by date:

Previous
From: Balkrishna Sharma
Date:
Subject: Re: db recovery after raid5 failure
Next
From: "Senthil Kumar G"
Date:
Subject: Re: Unable to start Statistics Collector