From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com> |
Subject: | Re: migration of 7.4 to 8.1 |
Date: | 2008-03-13 03:17:59 |
Message-ID: | 200803122318.00032.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2008-03-13 03:28:42 | Re: Encoding problems with migration from 8.0.14 to 8.3.0 on Windows |
Previous Message | Peter Kovacs | 2008-03-12 14:52:52 | Re: No initdb in Fedora 8 |