Re: migration of 7.4 to 8.1

On Wed, Mar 12, 2008 at 8:17 PM, Robert Treat
<xzilla(at)users(dot)sourceforge(dot)net> wrote:
> 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.

And if the OP is worried about running too new a version of pgsql,
8.2.6 is very mature. But if he's got 6 or more months until he goes
live, which is common, I'd recommend going to 8.3 which will be well
polished by then.