pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres with Sun Cluster HA/Solaris 10
3+ messages / 2 participants
[nested] [flat]
* Postgres with Sun Cluster HA/Solaris 10
@ 2007-09-05 22:33 Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
2007-09-07 08:23 ` Re: Postgres with Sun Cluster HA/Solaris 10 Markus Schiltknecht <markus@bluegap.ch>
0 siblings, 1 reply; 3+ messages in thread
From: Subbiah Stalin-XCGF84 @ 2007-09-05 22:33 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; +Cc: pgsql-performance
Hello All,
We have a postgres setup on solaris 10 with sun cluster for HA purposes.
2 nodes are configured in the cluster in active-passive mode
with pg_data stored on external storage. Everything is working as
expected however, when we either switch the resource group from one node
to other or rg restart on primary node, the apps fails with "An I/O
error occurred while sending to the backend." and doesn't recover back
from db failover. All queries to the db give the above error after
resource group restart.
Our app uses resin container db pooling, with following HA parameters
set. With same settings, the app recovers just fine with database
configured in non-cluster mode i.e. no sun cluster setup etc.
<database>
<jndi-name>jdbc/nbbsDB</jndi-name>
<driver type="org.postgresql.Driver">
<url>jdbc:postgresql://db-vip:5432/appdbname</url>
<user>appusr</user>
<password>apppass</password>
</driver>
<max-connections>100</max-connections>
<max-idle-time>5m</max-idle-time>
<max-active-time>6h</max-active-time>
<max-pool-time>24h</max-pool-time>
<connection-wait-time>30s</connection-wait-time>
<max-overflow-connections>0</max-overflow-connections>
<ping-table>pingtable</ping-table>
<ping>true</ping>
<ping-interval>60s</ping-interval>
<prepared-statement-cache-size>10</prepared-statement-cache-size>
<spy>false</spy>
</database>
Any pointers to debug this futher is greatly appreciated. We are running
postgres 8.2.4.
Other thing i noticed in pg_log/server.logs is that whenever i restart
postgres i get below error, when there is no other postgres running on
5432.
"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."
Thanks,
Stalin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres with Sun Cluster HA/Solaris 10
2007-09-05 22:33 Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
@ 2007-09-07 08:23 ` Markus Schiltknecht <markus@bluegap.ch>
2007-09-07 19:24 ` Re: Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
0 siblings, 1 reply; 3+ messages in thread
From: Markus Schiltknecht @ 2007-09-07 08:23 UTC (permalink / raw)
To: Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>; +Cc: pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres with Sun Cluster HA/Solaris 10
2007-09-05 22:33 Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
2007-09-07 08:23 ` Re: Postgres with Sun Cluster HA/Solaris 10 Markus Schiltknecht <markus@bluegap.ch>
@ 2007-09-07 19:24 ` Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
0 siblings, 0 replies; 3+ messages in thread
From: Subbiah Stalin-XCGF84 @ 2007-09-07 19:24 UTC (permalink / raw)
To: Markus Schiltknecht <markus@bluegap.ch>; +Cc: pgsql-admin@postgresql.org
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@bluegap.ch]
Sent: Friday, September 07, 2007 1:24 AM
To: Subbiah Stalin-XCGF84
Cc: pgsql-admin@postgresql.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-09-07 19:24 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-05 22:33 Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
2007-09-07 08:23 ` Markus Schiltknecht <markus@bluegap.ch>
2007-09-07 19:24 ` Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox