Well, I am mainly concerned with catastrophic failure. If 1st (main)
datacenter fails majorly (say fire, earthquake, db server dies etc), I need to
be able to restore websites/data quickly in another location. If I get a data
loss of say 6-12 hours during a major failure (which should never occ
Hello Dennis,
Dennis wrote:
Is there any feasible way to achieve geographical redundancy of postgresql
database?
As nobody mentioned it up until now: please check the very nice
documentation about High Availability and Failover here:
http://www.postgresql.org/docs/8.2/static/high-availabil
OK, well accepting data loss (even if it is "just" 6-12 hours worth)
really opens up a lot of possibilities.. EXCEPT that you also said you
want both sites to be able to modify data. Again, there is no real
multi-master replication available for postgres, so you'll have to have
both sites a
On Sat, 30 Dec 2006, Dennis wrote:
I was thinking of maybe just having 2nd location receive a PG dump (full
or incremental) every so often (an hour to 6 hours) and if the main
location fails majorly, restore the PG cluster from the dump and switch
DNS settings on the actual sites. I can make s
On 30 Dec 2006 at 0:22, Dennis wrote:
> I was thinking of maybe just having 2nd location receive a PG dump
> (full or incremental) every so often (an hour to 6 hours) and if the
Just curious - how do you do an incremental dump? I had to do
something similar recently, and ended up effectively rol
I was thinking of maybe just having 2nd location receive a PG dump (full or
incremental) every so often (an hour to 6 hours) and if the main location fails
majorly, restore the PG cluster from the dump and switch DNS settings on the
actual sites. I can make sure all website files are always in s
- 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 a
If you're sure that data loss is unacceptable no matter what happens
to either site, then I'm not aware of too many options. As I
understand it, pgpool can be configured to send data-altering queries
to multiple servers in order to simulate a multi-master cluster, but
it's never been clear
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 runni
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 in
10 matches
Mail list logo
