Re: migration of 7.4 to 8.1

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