From: mohan@physics.gmu.edu
Message-ID: <62763.138.88.163.115.1071687497.squirrel@physics.gmu.edu>
Date: Wed, 17 Dec 2003 13:58:17 -0500 (EST)
Subject: migration between databases and versions
To: <pgsql-sql@postgresql.org>
Importance: Normal
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

I have been Red Hat linux 7.3 on my prod server. I have been running
postgres 7.2 on it.
I would like to upgrade it to the newest version of postgres.
1) Is there a version for redhat 7.3.
2) How stable is postgres 7.4 ?
I have another critical isssue.
My database has now changed.In our new release of the product we have
added few more columns to some of the tables in the database. But the
production does not have these fields. All the fields in the tables in
production are also in developement version. But there are some extra
fields in developement database that are not in production. There is a lot
of data already in the production database.
Now i need to add move the data from the old production database to new
one which has certain extra fields. Please let me know if it is possible
to do this migration, if yes how? using pg_dump?

Eg: Old database with data
   has a Table named 'person' with fields A,B
 New Database to be put under prodcution
   also has an Table named 'person' with field A, B,C

If i do a pg_dump from old to new does it fill the A,B and leave C alone
or will it give an error given that C is not a null field.

Please help me

--Mohan