Integral PG DB replication
Hi:
Will DB replication be integral in v9? If so, when (approx) will that be out?
I have a need for this functionality to replicate a read-only copy of a DB where the master and slave are 2 time zones away. Estimating DML traffic, I'd say maybe a few dozen writes per hour, but busty, plus near 100% of them will be inside of a 10 hour period/day. (I realize that this would probably be considered very low by most standards).
This is a production DB, so I'm not too keen on being a V9 beta site. Actually, I am, but my management wil not be :-) .
-dave
On Jul 26, 2010, at 9:09 AM, Gauthier, Dave wrote:
Hi:
Will DB replication be integral in v9? If so, when (approx) will that be out?
I have a need for this functionality to replicate a read-only copy of a DB where the master and slave are 2 time zones away. Estimating DML traffic, I’d say maybe a few dozen writes per hour, but busty, plus near 100% of them will be inside of a 10 hour period/day. (I realize that this would probably be considered very low by most standards).
I'm assuming you mean a hot read-only copy of the DB, because you can currently do a warm replication with either WAL shipping or, in your case, even DRBD on a special partition would probably work just fine. But if you need a hot slave, then yes, you'll have to wait till 9 - assuming you need the replication to be built into core.
"Gauthier, Dave" <dave.gauthier@intel.com> writes:
Will DB replication be integral in v9? If so, when (approx) will that
be out?
Integral meaning all the cluster at a time, yes. You can help have it
out sooner by testing it and reporting your findings. I think the goals
are to have 9.0.0 out by mid august or about, so that's this summer.
Regards,
--
dim