migration between databases and versions

From: mohan(at)physics(dot)gmu(dot)edu
To: <pgsql-sql(at)postgresql(dot)org>
Subject: migration between databases and versions
Date: 2003-12-17 18:58:17
Message-ID: 62763.138.88.163.115.1071687497.squirrel@physics.gmu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Iain 2003-12-18 01:30:23 Re: migration between databases and versions
Previous Message Alessandro Depase 2003-12-17 16:04:11 Re: failed to build any 5-way joins