Re: Best high availability solution ? - Mailing list pgsql-general

From Arnaud Lesauvage
Subject Re: Best high availability solution ?
Date
Msg-id 447D4EC9.6020109@freesurf.fr
Whole thread Raw
In response to Re: Best high availability solution ?  (Markus Schiltknecht <markus@bluegap.ch>)
List pgsql-general
Markus Schiltknecht a écrit :
> Hi Arnaud,
>
> perhaps you can still use Slony-I for replication and have another tool
> automatically handle connections (check out PgPool[1] or SQLRelay[2]).
>
> Or go for a middleware replication solution. Check C-JDBC[3], perhaps
> there is something similar for ODBC?
>
> LifeKeeper seems to handle replication at a lower level (filesystem,
> distributed memory, or such) and does not seem to be very well suited
> for database replication. However, I've had just a quick glance at the
> website.
>
> Hope that helps
>
> Markus
>
> [1]: http://pgfoundry.org/projects/pgpool/
> [2]: http://sqlrelay.sourceforge.net/
> [3]: http://c-jdbc.objectweb.org/


Hi Markus !

Thanks for your suggestions, they are very helpful !
pgpool and SQLRelay looked really great, but there are no ports
for win32... :(
Maybe some kind of virtual-ip software would do the trick, but I
am still looking for it !

--
Arnaud


pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore
Next
From: "Magnus Hagander"
Date:
Subject: Re: Best high availability solution ?