Sure, there are lots of ways. Factors that start constraining things
are:
- do both sites have to be online (making changes to the data) at the
same time?
- how tightly do both sites have to stay in sync?
- is data loss acceptable if one site suffers a disaster?
- what platform are you running on?
- how much throughput latency do you have between sites?
- how much downtime is acceptable in switching sites?
On Dec 26, 2006, at 11:41 PM, Dennis wrote:
Is there any feasible way to achieve geographical redundancy of
postgresql database?
Say you have a website which uses PG on the backend to read/write
data and you want to have the website running on 2 separate servers
distributed geographically and have the data synchronize somehow
over the internet.
In case one data center fails, website is still up and running from
2nd geographical location (from say 2nd DNS server).
Thank you.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
