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