Skip site navigation (1) Skip section navigation (2)

Re: clustering with shared storage

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Gary Webster <webster(at)lexmark(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: clustering with shared storage
Date: 2012-03-20 19:58:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

On Tue, 2012-03-20 at 15:26 -0400, Gary Webster wrote:

> The best I've found is here:
> but, it doesn't go into setup details.

has a newer version (still not that detailed, but much better)

> I have a few questions/issues, but figure I will attack it piecemeal, in
> chronological order.
> RHCS is handling the fencing.
> I have installed postgres on the local drive of the primary, with pgdata on
> the shared drive.
> I am generally using the EnterpriseDB install package for v9.1.3 .
> So, first, just how to install postgres on the secondary?

Just install the binaries -- don't initdb, and then use the shared disk
as the $PGDATA. RHCS will mount the shared filesystem to only one
server, and that one will use the $PGDATa.

> 1)  If I leave it as secondary (non-active), it can't see the shared drive.
>  Is this correct/OK ?

It *can* see, but it does not see (or it should not see) and it *cannot*

> If so, it will create its own pgdata locally, which is later ignored?
> or
> 2)  Do I make it primary, then point its pgdata to the already existing
> data during install ?!?

See above.

Principal Systems Engineer @ EnterpriseDB:
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community:,  Twitter:

In response to


pgsql-admin by date

Next:From: amador alvarezDate: 2012-03-20 20:33:13
Subject: Re: clustering with shared storage
Previous:From: Gary WebsterDate: 2012-03-20 19:26:18
Subject: clustering with shared storage

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group