Re: Regarding the shared disk fail over cluster configuration - Mailing list pgsql-general

From Debasis Mishra
Subject Re: Regarding the shared disk fail over cluster configuration
Date
Msg-id 1320249339034-4958449.post@n5.nabble.com
Whole thread Raw
In response to Re: Regarding the shared disk fail over cluster configuration  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
Responses Re: Regarding the shared disk fail over cluster configuration  (Alan Hodgson <ahodgson@simkin.ca>)
Re: Regarding the shared disk fail over cluster configuration  (Scott Mead <scottm@openscg.com>)
List pgsql-general
Thanks a lot Ondrej Ivanic.I have few more doubts.

1)While installing the postgress it asks for the data directory,which i
refer to SAN volume(Shared LUN)-(example - /dbdata/pgsqldata).

After that i am exporting $PGDATA= SAN Volume(example - /dbdata/pgsqldata).
Where /dbdata is the shared LUN .

Then I am running initdb - but it is not running successfully. The Error is
/dbdata/pgsqldata is not empty.

Because I can understand while installation postgress creates
files/directory in the data folder. While running initdb also it is trying
to create some directory which is already present.

So I am not sure how to go ahead with this scenario.

2) Regarding the shared disk failover clustering you mentioned that if
primary fails , cluster should bring it down and start postgres in secondary
node.

My doubt is - Whether cluster should start the postgres service in secondary
node during failover or postgress will be running always. My undersatnding
was in both the node postgress will be running and pointing to shared
dbdata. And if node1/primary fails then cluster software should bring
node2/secondary up.once it will bring node2 online there postgress must be
running already.

Is this feasible?

Thanks,
Debasis

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Regarding-the-shared-disk-fail-over-cluster-configuration-tp4952316p4958449.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Samba
Date:
Subject: equivalent to "replication_timeout" on standby server
Next
From: Robert Treat
Date:
Subject: Re: Server move using rsync