Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id BFFB2632626
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 20 Feb 2010 19:29:07 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 60374-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 20 Feb 2010 23:28:57 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com
	[209.85.160.46])
	by mail.postgresql.org (Postfix) with ESMTP id 39EDD6325E3
	for <pgsql-admin@postgresql.org>; Sat, 20 Feb 2010 19:28:57 -0400 (AST)
Received: by pwj8 with SMTP id 8so1367317pwj.19
	for <pgsql-admin@postgresql.org>; Sat, 20 Feb 2010 15:28:55 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:sender:received:in-reply-to
	:references:from:date:x-google-sender-auth:message-id:subject:to:cc
	:content-type; bh=1GEoM8KulEsMvDttb9H6S+7A7Ap0l6Y4kev1GZVmPog=;
	b=Yl5FTAUzpgpDFJgQepZXBYgTN80Qp3KoewMBIlh9O/ddX9iomL8mKityVAJFCEqKID
	tglTO0bS1Rr90PIJY04lHjtWKJ9HEO6lA7uRzOmmUVU4Zd1Ji8y4Yb7CBZnIPg4aNZgV
	s4noH4faEO0E7fO4g+gzW8OT2WqwLdTDM8tu0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:in-reply-to:references:from:date
	:x-google-sender-auth:message-id:subject:to:cc:content-type;
	b=cSoO2NRzgQD8hKnngKtqQYINELndabnMZyCXEjHRWrIWbkdswgsabQRgAT5ZQxP7Zd
	qg1CmRXPS9ja4ccUbaLTaZD+h8G/JJRP5JP53mHMWOv8mO7iQ4Yo8Zi9gy9hPSQDJUJo
	L8hTlqe3zgQB/axXyPQTX3nckd9vMHRj9gPlM=
MIME-Version: 1.0
Received: by 10.141.5.9 with SMTP id h9mr8192696rvi.247.1266708147124;
 Sat, 20
	Feb 2010 15:22:27 -0800 (PST)
In-Reply-To: <4B806560.2000104@gmail.com>
References: <4B805376.80705@FastMail.fm> <4B806560.2000104@gmail.com>
From: Greg Stark <gsstark@mit.edu>
Date: Sat, 20 Feb 2010 23:22:07 +0000
X-Google-Sender-Auth: 3d7f15074f7b2547
Message-ID: <407d949e1002201522o4fbafa3r2503017f1529f86a@mail.gmail.com>
Subject: Re: upgrading, but learned about pg_dumpall too late
To: Andrzej Zawadzki <zawadaa@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 201002/159
X-Sequence-Number: 33762

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