PostgreSQL and 2-node failover cluster solutions

From: Chris Miles <chris_pg002(at)psychofx(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: chris_pg002(at)psychofx(dot)com
Subject: PostgreSQL and 2-node failover cluster solutions
Date: 2002-10-04 18:05:28
Message-ID: 20021004190528.E9444@psychofx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, we have 2 PostgreSQL servers running multiple instances and would like
to automate failover between them. We store db data on NFS storage on
dedicated Netapps. We can currently perform manual failover by dropping
the instance on one server and starting in on the other (the init scripts
handle bringing virtual IP up/down and the NFS volume is automounted as
needed).

My question to you: are there any simple, reliable and free cluster/fail-over
(whatever you'd like to call it) solutions that you know of to automate
the above? I'm prepared to give a bit on the simple and free if necessary,
although reliability is pretty important.

I have been looking at Kimberlite, but it doesn't look like it supports NFS
shared storage, only locally attached. Otherwise it is almost perfect.

Many other offerings floating around are either expensive commercial, or
overly complex requiring kernel patching and complicated setups.

Any suggestions appreciated. Especially if you've already solved this!

Regards,
Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-10-04 18:14:23 Re: Cannot start the PostgreSQL v7.1.3 database
Previous Message Roland Roberts 2002-10-04 17:35:31 Re: [GENERAL] Fast Deletion For Large Tables