[luau] PostgreSQL Replication/Clustering solution

Deven Phillips deven at hcc.hawaii.edu
Tue Jun 10 15:12:00 PDT 2003


Takuya,

	I'm afraid the only method I have heard of doing thiis is to use a load 
balancer or a SQL proxy. Check freshmeat for SQL proxy and  I think that can 
help.

Deven

On Tuesday 10 June 2003 09:05 am, Takuya Nakayama / 中山 卓也 wrote:
> Hello:
>
> Is anyone know, how to setup Replication/Clustering on two PostgreSQL
> servers?  I have two Debian/GNU Linux servers with running PostogreSQL
> databases.  Two servers are identically same hardware and software
> configuration now.  Now, I would like to setup one server for primary, the
> other server for secondly backup server configuration.  With my budget, I’m
> unable to add external RAID hardware for the servers.  I may possible to
> add additional Ethernet cards for data replication between the servers. 
> Also, client computers should automatically switch the servers when primary
> server fails down.  If anyone has any idea, please let me know.
>
> Best regards,
>
> Takuya Nakayama
>
>
> _______________________________________________
> LUAU mailing list
> LUAU at videl.ics.hawaii.edu
> http://videl.ics.hawaii.edu/mailman/listinfo/luau




More information about the LUAU mailing list