High availability with Postgres

--0016e64696e83bc912048978ca3e
Content-Type: text/plain; charset=ISO-8859-1

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 ?

Regards,
Elior

--0016e64696e83bc912048978ca3e
Content-Type: text/html; charset=ISO-8859-1

Re: High availability with Postgres

On Sun, Jun 20, 2010 at 10:36, Elior Soliman 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 ?

Yeah, I have used linux + heartbeat + stonith (shoot the other node in
the head) successfully in the past. Basically if you do this want
want to be really really really careful that both machines are not
running postgres at the same time.

[ Note, I dont run this any more instead I use a simpler pitr setup.
You can of course still use shared external storage, you just need 2
copies of the database :-( ]

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: High availability with Postgres

On Sun, Jun 20, 2010 at 10:36 AM, Elior Soliman
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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin