On Thu, Jan 25, 2007 at 15:43:19 +1100, Chris <dmagick@xxxxxxxxx> wrote: > Carlos wrote: > >What would be the faster way to convert a 7.4.x database into an 8.x > >database? A dump of the database takes over 20 hours so we want to > >convert the database without having to do a dump and resptore. > > That's your only option as far as I know (I'm sure someone will correct > me if that's not the case). > > You can't do a binary conversion or anything like that because the > postgres internals are different between major versions. People use slony to do this. You can ask on the slony list for more details.
