Re: Regarding the shared disk fail over cluster configuration

From: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Regarding the shared disk fail over cluster configuration
Date: 2011-11-02 04:21:15
Message-ID: CAM6mieKdM5Rq3GPRHuz5GK7KZvaX6P04dF-mBzZ6OUj4ZbbBkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On 2 November 2011 02:00, Debasis Mishra <debasis1982(at)gmail(dot)com> wrote:
> Thanks a lot for your replay. I just wanna know whether it is required for
> me to run initdb or setting the PGDATA environment variable is enough?

Master needs to be properly initialised & configured
- install postgres
- run initdb
- install your application schema,...
- point $PGDATA to SAN volume

Secondary:
- install Postgres
- point $PGDATA to SAN volume (volume is mounted on primary!)

During failover clustering software has to:
- shutdown primary (usually: STONITH (Shoot The Other Node In The
Head) aka fencing)
- mount SAN volume on secondary
- startup postgres on secondary

--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Royce Ausburn 2011-11-02 04:27:30 Re: Subselects in select expressions
Previous Message Eric Smith 2011-11-02 03:58:26 Re: adding a column takes FOREVER!