From: Andrzej Zawadzki <zawadaa@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: upgrading, but learned about pg_dumpall too late
Date: Sun, 21 Feb 2010 20:20:03 +0100
Message-ID: <4B818763.6030502@gmail.com> (raw)
In-Reply-To: <407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com>
References: <4B805376.80705@FastMail.fm>
<4B806560.2000104@gmail.com>
<407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com>
On 21.02.2010 00:22, Greg Stark wrote:
> 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.
>
>
True bat not easier for beginner ;-)
> 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.
>
BTW. Isn't better make static (?) (stand alone) build of pg_dump(all)?
Postgresql engine could be 7.1 and pg_dump will in 8.1 version.
Much easier to upgrade on one machine.
--
Andrzej Zawadzki
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: zawadaa@gmail.com
Subject: Re: upgrading, but learned about pg_dumpall too late
In-Reply-To: <4B818763.6030502@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