Re: Best high availability solution ?

From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
To: Markus Schiltknecht <markus(at)bluegap(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Best high availability solution ?
Date: 2006-05-31 08:07:37
Message-ID: 447D4EC9.6020109@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2006-05-31 08:38:33 Re: Best high availability solution ?
Previous Message Magnus Hagander 2006-05-31 08:00:18 Re: Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore