Re: migration of 7.4 to 8.1

On Wed, Mar 12, 2008 at 8:17 PM, Robert Treat
<xzilla@users.sourceforge.net> wrote:
> On Wednesday 12 March 2008 01:27, sathiya psql wrote:
>  > Is there any article describing the migration database from postgresql
>  > 7.4to 8.1
>
>  I don't know of any specific references, but the process is not fundementally
>  different from any other major version upgrade. You'll want to do a schema
>  only dump of your current database any load that into the 8.1 database. Once
>  you feel comfortable that this works ok, try a data only dump and load that
>  into the 8.1 server.  Once you comfortable all that works, you're ready to
>  upgrade.
>
>  I will note that if you're planning to upgrade, I'd recommend going stright to
>  8.3.  8.1 is a few years old, and 8.3 provides a number of features and
>  improvement you'll benefit from. Unless you have a strong reason to do
>  otherwise, go to 8.3. HTH.

And if the OP is worried about running too new a version of pgsql,
8.2.6 is very mature.  But if he's got 6 or more months until he goes
live, which is common, I'd recommend going to 8.3 which will be well
polished by then.