From: Greg Stark <gsstark@mit.edu>
To: Andrzej Zawadzki <zawadaa@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: upgrading, but learned about pg_dumpall too late
Date: Sat, 20 Feb 2010 23:22:07 +0000
Message-ID: <407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com> (raw)
In-Reply-To: <4B806560.2000104@gmail.com>
References: <4B805376.80705@FastMail.fm>
<4B806560.2000104@gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsstark@mit.edu, zawadaa@gmail.com
Subject: Re: upgrading, but learned about pg_dumpall too late
In-Reply-To: <407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox