Re: upgrading, but learned about pg_dumpall too late

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Andrzej Zawadzki <zawadaa(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: upgrading, but learned about pg_dumpall too late
Date: 2010-02-20 23:22:07
Message-ID: 407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sat, Feb 20, 2010 at 10:42 PM, Andrzej Zawadzki <zawadaa(at)gmail(dot)com> wrote:
> Downgrade to 7.4
> Dump
> Upgrade
> Restore
>

Actually that's not the best way.

The best way is to install 7.4 and 8.1.19 (not 8.1.11 which has known
bugs) at the same time.

Use the pg_dump *from* *8.1.19* to connect to the 7.4 server and dump
the database.
Then shut down 7.4 and start up 8.1.19 and use pg_restore to restore
the database.

--
greg

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nilesh Govindarajan 2010-02-21 01:57:28 Re: Backups
Previous Message Andrzej Zawadzki 2010-02-20 22:42:40 Re: upgrading, but learned about pg_dumpall too late