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

Re: PostgreSQL cluster solution

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL cluster solution
Date: 2009-12-23 18:02:16
Message-ID: 025b05698f44c54f204eaeac2af3e0f7@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----                                  
Hash: RIPEMD160                                                     


> I want a multi-master solution since that would 
> best spread the write load.
...
> What I want

> Mutli master

Might also look at Bucardo

> Failover and failback (if that makes sense for a multimaster solution...)

No, not really. :(

> Synchronize after downtime

Everything should do that.

> Load-balancing
> Once a client is connected it stays connected to that server (possibly
> through LVS)

That's generally handled by something else.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200912231301
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAksyWw8ACgkQvJuQZxSWSsheYQCgyxG5U/xzFzzUmaNVAEF5hb7q
fp4AoP6YSfACBCdVQziw9MKKfJGTLTvj
=BeBe
-----END PGP SIGNATURE-----



In response to

pgsql-novice by date

Next:From: sfarley1Date: 2009-12-25 17:42:56
Subject: PostgreSQL 8.3 and Windows 7
Previous:From: Pushpendra Singh ThakurDate: 2009-12-23 14:31:38
Subject: Re: PostgreSQL cluster solution

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