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

Re: Postgres with Sun Cluster HA/Solaris 10

From: "Subbiah Stalin-XCGF84" <SSubbiah(at)Motorola(dot)com>
To: "Markus Schiltknecht" <markus(at)bluegap(dot)ch>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres with Sun Cluster HA/Solaris 10
Date: 2007-09-07 19:24:12
Message-ID: BF8D37611DA14544B3A47B8FF0559446019C0A9E@ct11exm61.ds.mot.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
Yes, it's a shared-disk failover solution as described in [1] and only
node will run the pg instance. We got it fixed by setting ping-interval
in resin from 60s to 0s. It's more like validate every connection before
giving to app to process. 

> That's talking about IPv6. Are you using IPv6? Is sun cluster doing
something magic WRT your network?

Well we see this error on a stand-alone sol 10 box with no cluster. How
do I check if it's setup to use IPv6 or not.

Thanks,
Stalin

-----Original Message-----
From: Markus Schiltknecht [mailto:markus(at)bluegap(dot)ch] 
Sent: Friday, September 07, 2007 1:24 AM
To: Subbiah Stalin-XCGF84
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgres with Sun Cluster HA/Solaris 10

Hi,

Subbiah Stalin-XCGF84 wrote:
> Any pointers to debug this futher is greatly appreciated.

I'm not quite sure, how sun cluster is working, but to me it sounds like
a shared-disk failover solution (see [1] for more details).

As such, only one node should run a postgres instance at any time. Does
sun cluster take care of that?

> "LOG:  could not bind IPv6 socket: Cannot assign requested address
> HINT:  Is another postmaster already running on port 5432? If not, 
> wait a few seconds and retry."

That's talking about IPv6. Are you using IPv6? Is sun cluster doing
something magic WRT your network?

(BTW, please don't cross post (removed -performance). And don't reply to
emails when you intend to start a new thread, thanks.)

Regards

Markus

[1]: Postgres Documentation High Availability and Load Balancing
http://www.postgresql.org/docs/8.2/static/high-availability.html


In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2007-09-07 20:04:41
Subject: Re: SAN vs Internal Disks
Previous:From: Simon RiggsDate: 2007-09-07 19:00:16
Subject: Re: DRBD and Postgres: how to improve the perfomance?

pgsql-admin by date

Next:From: DIEGO ARMANDO LOPEZ PINILLADate: 2007-09-07 20:03:48
Subject: Telecom(Colombia) - Error postgresql
Previous:From: Tom LaneDate: 2007-09-07 18:38:39
Subject: Re: Postgres User Password File????

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