On Mon, 6 Oct 2008, Scott Marlowe wrote:
On Mon, Oct 6, 2008 at 9:34 AM, Markus Wanner <markus@bluegap.ch> wrote:Once Postgres supports in-place upgrades between major versions, this issue is solved.It has in the past but apparently the work required in coding and testing was too much and it the upgrade in place stuff was abandoned. Someone please correct me if I'm wrong and someone is working on it again.
There's a prototype being actively worked on and if we're lucky it will debut in 8.4 this March. See http://archives.postgresql.org/message-id/48BB10A2.60503@sun.com for the last code submission there and http://wiki.postgresql.org/wiki/In-place_upgrade for an outline of the project.
-- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD