Re: 10 weeks to feature freeze (Pending Work)
decibel <decibel@decibel.org>
From: Jim Nasby <decibel@decibel.org>
To: Andrew Hammond <andrew.george.hammond@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2007-02-07T03:43:48Z
Lists: pgsql-hackers
On Feb 5, 2007, at 12:53 PM, Andrew Hammond wrote: > On Jan 26, 2:38 pm, t...@sss.pgh.pa.us (Tom Lane) wrote: >> Rick Gigger <r...@alpinenetworking.com> writes: >>> I thought that the following todo item just barely missed 8.2: >>> "Allow a warm standby system to also allow read-only statements >>> [pitr] >> >> No, it's a someday-wishlist item; the work involved is not small. > > Slony1 has supported log-shipping replication for about a year now. It > provides similar functionality. Not really.... 1) It's not possible for a PITR 'slave' to fall behind to a state where it will never catch up, unless it's just on inadequate hardware. Same isn't true with slony. 2) PITR handles DDL seamlessly 3) PITR is *much* simpler to configure and maintain -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)