DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:content-type:content-transfer-encoding;
	b=FBkpHBDSGz1ye1DluhcHVRC2Bj++2j3AD3MMpjQ6aS/+28OF/6WRqW4zP6bykjn2bP
	8zp2itmweDEpPMDmqALYCX0xVq7ybwZJQFaY0FuulQCp1fZi1KCg/BKIkqCXtr8skOB/
	ZWAGjdxA/t/5d/92Sh+VjQ2K4X2CbVnqdhESY=
Message-ID: <4B818763.6030502@gmail.com>
Date: Sun, 21 Feb 2010 20:20:03 +0100
From: Andrzej Zawadzki <zawadaa@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.7) Gecko/20100215 Lightning/1.0b1 Icedove/3.0.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: upgrading, but learned about pg_dumpall too late
References: <4B805376.80705@FastMail.fm> <4B806560.2000104@gmail.com>
	<407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com>
In-Reply-To: <407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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