Re: [HACKERS] 8.1 beta1 -> beta2 upgrade question

2005-10-12 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > There has been talk in the past about creating a tool for in-place > upgrades. The most complete description of the needed work I've seen > posted to date is here: > http://archives.postgresql.org/pgsql-hackers/2003-12/msg00379.php > There was another p

Re: [HACKERS] 8.1 beta1 -> beta2 upgrade question

2005-10-12 Thread Eric Sproul
On Wed, 2005-10-12 at 13:00 -0400, Eric Sproul wrote: > We are interested in finding a way to directly translate the > data files from one version to the next. We can devote resources to > work on this if the development team can give us guidance. Please excuse the followup to myself... We will,

Re: [HACKERS] 8.1 beta1 -> beta2 upgrade question

2005-10-12 Thread Alvaro Herrera
Eric Sproul wrote: Hi, > We are testing a 1TB database on 8.1 beta 1. The upgrade path to beta 2 > (and presumably from beta 2 to the next release, all the way through > production) requires a full export and import. Even on our beefy > hardware (quad-Opteron, 16GB RAM) we are looking at a 26-h

Re: [HACKERS] 8.1 beta1 -> beta2 upgrade question

2005-10-12 Thread Eric Sproul
On Wed, 2005-10-12 at 11:20 -0600, Aly S.P Dharshi wrote: > Would it be possible to replicate your database to a Slony based beta 2 > and then promote this to a master whilst upgrading the old master ? I > presume that Slony will do the trick with the 8.1 betas Aly, We don't have the online stor