X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 929C1D1B906
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 18 Dec 2003 09:36:05 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 88612-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 18 Dec 2003 05:35:36 -0400 (AST)
Received: from Gateway.bksys.co.in (unknown [61.3.252.134])
	by svr1.postgresql.org (Postfix) with ESMTP id 3F3CBD1B4C2
	for <pgsql-sql@postgresql.org>; Thu, 18 Dec 2003 05:35:32 -0400 (AST)
Received: from bksys.co.in (mail.bksys.co.in [192.168.1.1])
	by Gateway.bksys.co.in (8.11.6/8.11.6) with ESMTP id hBI9ZW927447;
	Thu, 18 Dec 2003 15:05:32 +0530
Received: from Bhuvan.bksys.co.in (Bhuvan.bksys.co.in [192.168.1.71])
	by bksys.co.in (8.11.6/8.8.5) with ESMTP id hBI9ZWI21306;
	Thu, 18 Dec 2003 15:05:32 +0530
Subject: Re: migration between databases and versions
From: "A.Bhuvaneswaran" <bhuvan@symonds.net>
To: mohan@physics.gmu.edu
Cc: pgsql-sql@postgresql.org
In-Reply-To: <62763.138.88.163.115.1071687497.squirrel@physics.gmu.edu>
References: <62763.138.88.163.115.1071687497.squirrel@physics.gmu.edu>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-dGaFbNxAPihHRhqdBnig"
Message-Id: <1071740418.1545.24.camel@Bhuvan.bksys.co.in>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Thu, 18 Dec 2003 15:10:19 +0530
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200312/127
X-Sequence-Number: 16293

--=-dGaFbNxAPihHRhqdBnig
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

> I would like to upgrade it to the newest version of postgres.
> 1) Is there a version for redhat 7.3.

Yes. You can run postgresql 7.2.x, 7.3.x & 7.4 on redhat 7.3.

> 2) How stable is postgres 7.4 ?

7.4 is stable. If i am in your position, i would rather wait for 7.4.3
or 7.4.4 for that matter.

> 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 you are *very* sure that,=20

1) Columns are added, but not deleted
2) Tables are added, but not deleted
3) Tables are not renamed

then, you can follow the below steps to address your need:

1) IMPORTANT: Dump production database (schema & data). It is for safety
reason.
2) Dump production database (data only, using -a & -D option). Refer the
man page for the significance of -a & -D option.
3) Dump development database (schema only)
4) Restore development database (schema only)
5) Restore the dump which is taken in step 2 (data only)

Hope it addresses your need.

regards,
bhuvaneswaran

--=-dGaFbNxAPihHRhqdBnig
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA/4XYCL2UFujVh8ToRAr/CAJ9EZLpUkF8hyYGxdYggW5RyIXrW7ACdGyDw
dKGYjprmrkl6H8BrZczBrXw=
=MnCy
-----END PGP SIGNATURE-----

--=-dGaFbNxAPihHRhqdBnig--