- Yes, both sites have to be online and changing data at the same time. - data loss is unacceptable - platform is Gentoo Linux - downtime of up to 1 day is acceptable as long as there is no data loss - throughput latency -> internet over 10megabit line
Ben <[EMAIL PROTECTED]> wrote: 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 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
