upgrade questions - Mailing list pgsql-general

From Arcterex
Subject upgrade questions
Date
Msg-id 37EFB1F1.FC840F77@ufies.org
Whole thread Raw
List pgsql-general
Howdy everyone.

I'm in the process of moving a postgres database from one box to another
and have a couple of questions on the best way to do things.

I'm moving from a RH 6 box using postgres 6.4 to a debian 2.1 box with
postgres 6.3.  It's not backwards compatible, so I can't access the
database at all, except for when I do a "\c <database>" it tells me it's
the wrong version number.

Now the latest debian has the 6.5 version of postgres, but I can't
upgrade to that package becuase the dependancies would break
*everything*.  I could download/compile the postgres sources and build
things here, trying to keep the old directories and directory structure,
and *hope* that that works...

Does anyone know of a good way to move the data across?  Or maybe a way
to convert from 6.4 to 6.3 somehow?

Thanks a lot..

alan

pgsql-general by date:

Previous
From: Elmar Haneke
Date:
Subject: Re: [GENERAL] Anyone doing a native NT port?
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Anyone doing a native NT port?