From: Robert Treat <robert@omniti.com>
To: pgsql-admin@postgresql.org
Cc: Mageshwaran <j_mageshwaran@sifycorp.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-general@postgresql.org
Subject: Re: Postgresql Help
Date: Mon, 23 Apr 2007 22:15:59 -0400
Message-ID: <200704232216.00234.robert@omniti.com> (raw)
In-Reply-To: <462C425B.7090802@sifycorp.com>
References: <462C425B.7090802@sifycorp.com>
On Monday 23 April 2007 01:21, Mageshwaran wrote:
> Hi ,
>
> I am new to postgresql, I have been assigned a task of upgrading
> postgresql to higher version.
> In our company we are using 7.1.1,7.1.3,7.4.5 versions of postgresql,
> can you please tell me which is the stable and suitable version in 8.x
> version.
>
If you plan to do your upgrades within the next 4 months, you'll want to
target 8.2.4. If you plan to upgrade after that, then 8.3 is the version
you'll want (it is currently expected to be released around July).
You should be aware that upgrading from 7.1.x versions is likely to be a
somewhat intensive process since, while it should be backwards compatible,
recent versions of pg_dump almost certainly hasn't recieved much testing
against 7.1.x versions. (I'd almost recommend upgrading to an intermediate
version like 7.4.x, but it probably isn't worth it... just make sure that you
keep a copy of your 7.1 databases running until your done testing, and make
sure to test your applications thoroughly. Also don't forget that any
applications /drivers/ libraries that are built against 7.1 should be
updated / recompiled against newer versions as well. HTH.
--
Robert Treat
Database Architect
OmniTI Technology Firm
http://www.omniti.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: robert@omniti.com, j_mageshwaran@sifycorp.com, bruce@momjian.us, pgsql-general@postgresql.org
Subject: Re: Postgresql Help
In-Reply-To: <200704232216.00234.robert@omniti.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox