Re: Please implement simple failover scenario

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Enrico Olivelli - Diennea *EXTERN*" <enrico(dot)olivelli(at)diennea(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Please implement simple failover scenario
Date: 2014-09-19 10:55:25
Message-ID: A737B7A37273E048B164557ADEF4A58B17D41ACC@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Enrico Olivelli - Diennea wrote:
> we are going to switch from Oracle to PostgreSQL and we would like to setup a simple hot-standby/warm-
> standby replication scenario.
>
> Actually your JDBC driver does not have native support for failover to the slave host.

Why don't you implement that on a lower level with virtual IP addresses?

You could configure failover so that a certain IP address always points
to the current master. That way you only have to reestablish the connection
when it fails.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Enrico Olivelli - Diennea 2014-09-19 11:07:12 R: Please implement simple failover scenario
Previous Message Enrico Olivelli - Diennea 2014-09-19 10:44:43 Disk buffering of resultsets