On November 2, 2011 08:55:39 AM Debasis Mishra wrote:
> 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.
You definitely cannot have 2 postmasters running against the same shared disk.
The cluster software will need to start PostgreSQL on the secondary node after
taking over the IP address and shared disk resource.