Re: [GENERAL] Integral PG DB replication
"Gauthier, Dave" 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Integral PG DB replication
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.
[GENERAL] 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