Postgres Pro
Downloads
Home   >   mailing lists

Re: upgrading, but learned about pg_dumpall too late - Mailing list pgsql-admin

From Greg Stark
Subject Re: upgrading, but learned about pg_dumpall too late
Date
Msg-id 407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com
Whole thread Raw
In response to Re: upgrading, but learned about pg_dumpall too late  (Andrzej Zawadzki <zawadaa@gmail.com>)
Responses Re: upgrading, but learned about pg_dumpall too late
List pgsql-admin
Tree view 
On Sat, Feb 20, 2010 at 10:42 PM, Andrzej Zawadzki <zawadaa@gmail.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

pgsql-admin by date:

Previous
From: Andrzej Zawadzki
Date:
Subject: Re: upgrading, but learned about pg_dumpall too late
Next
From: "Kevin Grittner"
Date:
Subject: Re: pg_dump/restore problems