Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 3252D632987
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  2 Mar 2009 04:11:35 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 97015-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  2 Mar 2009 04:11:24 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from shaykin.bluegap.ch (shaykin.bluegap.ch [78.46.81.73])
	by mail.postgresql.org (Postfix) with ESMTP id B3760632973
	for <pgsql-admin@postgresql.org>; Mon,  2 Mar 2009 04:11:24 -0400 (AST)
Received: from [192.168.77.34] (p4FC1A58C.dip0.t-ipconnect.de
	[::ffff:79.193.165.140])
	(AUTH: CRAM-MD5 markus@bluegap.ch, TLS: TLSv1/SSLv3, 256bits,
	AES256-SHA)
	by shaykin.bluegap.ch with esmtp; Mon, 02 Mar 2009 09:11:22 +0100
	id 000000000173C003.0000000049AB94AA.00004992
Message-ID: <49AB94A9.1060907@bluegap.ch>
Date: Mon, 02 Mar 2009 09:11:21 +0100
From: Markus Wanner <markus@bluegap.ch>
User-Agent: Mozilla-Thunderbird 2.0.0.19 (X11/20090103)
MIME-Version: 1.0
To: Bryan Keith <bryan@ideotrope.org>
CC: pgsql-admin@postgresql.org, Scott Marlowe <scott.marlowe@gmail.com>,
	"Daniel J. Summers" <daniel@djs-consulting.com>
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org>
	<49A9F8DC.2080309@djs-consulting.com>
	<dcc563d10902281956s74a74c39k2d8c309d416544d7@mail.gmail.com>
	<1237.71.208.251.23.1235882478.squirrel@ideotrope.org>
	<1168.71.208.251.23.1235918386.squirrel@ideotrope.org>
	<49AB05D4.8060309@bluegap.ch>
	<1248.71.208.251.23.1235955413.squirrel@ideotrope.org>
In-Reply-To: <1248.71.208.251.23.1235955413.squirrel@ideotrope.org>
X-Enigmail-Version: 0.95.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/11
X-Sequence-Number: 31511

Hi,

Bryan Keith wrote:
> How can I install postgres 8.2 without messing up the data in
> /var/lib/postgresql/8.2/main?

The way Postgres packages for Debian (and Ubuntu) are built, that's no
problem. Just install postgresql-8.2 again. After the upgrade, you can
remove the package and the data directory (after having made sure you
don't need it anymore).

> Can I just copy that to a new location and copy it back after the
> installation?  Or...?

Not necessarily required, but having a backup is always a good thing.

> How do I install postgres 8.2?  I think I installed 8.2 with something
> like sudo apt-get install postgresql, but that will install 8.3 now, I
> think.

Try: sudo apt-get install postgresql-8.2

I'm not sure about Ubuntu. Probably 8.2 isn't included in Intrepid
anymore. (packages.ubuntu.com is currently not responding) (Why don't
you stay at a LTS ubuntu version for a database server?)

If that's the case, try adding the Hardy Heron repository back to
/etc/apt/sources.list. If postgres-8.2 isn't available on Intrepid Ibex,
it then falls back to that from Hardy Heron.

After having installed that, you should be able to access your Postgres
8.2 data again. You can then do a dump/restore cycle to migrate from 8.2
to 8.3. You might want to check out pg_upgradecluster for that.

Good Luck

Markus Wanner