[Pgcluster-general] Newbie Seeking Help

[Matthew]

Hi John,
  Its actually more like this:

+--------+                   +-------+
|  NY Pg |------VPN/LL-------| LA Pg |
+--------+                   +-------+
      \                     /
     VPN/LL              VPN/LL
        \                 /
         \               /
          +-------------+
          |  Houston Pg |
          +-------------+

VPN = VPN over Public Internet
LL = Leased, Private, Point-To-Point link

Primary access will be over LL and VPN is for backup if LL goes down.

-Matthew

John Gardner wrote:
> 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
>