[Pgcluster-general] Newbie Seeking Help

[John Gardner]

Matthew wrote:
> Hello,
>  We are currently attempting to setup/implement a HA Postgres install
> using PG 8.2.4 across geographic locations (Specifically LA, Houston and
> NY).
> 
>  We'd like to implement this configuration but without the load balancers:
> 	http://pgcluster.projects.postgresql.org/1_3/configuration.html
> 
> At LA and NY we'd like to have 1 data node and 1 replicator. At Houston
> just a data node.
> 
> A) Is this configuration possible?
> B) Is this possible with the latest version of pgCluster and 8.2.4?
> 
> I ask B) because I tried downloading 1.3c and all the patch's failed.
> 
> Any help would be appreciated.
> 

Matthew

Are you planning something like this?

+--------+           +------------+           +-------+
|  NY Pg |----VPN----| Houston Pg |----VPN----| LA Pg |
+--------+           +------------+           +-------+

If so, I think yes it would work in principal.  You could probably do a
single INSERT or UPDATE and they would appear in all three backends, but
 would it really work in a production environment when many transactions
are taking place simultaneously?  I have my doubts.

Try using this to get you started:

http://www.pgcluster.org/wiki/Example

John

-- 
John Gardner - Tagish Ltd.
Infrastructure Manager
T: 01665 833 322
F: 01665 830 695
D: 01665 833 310