Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id ED36E632DCC
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  1 Mar 2009 18:02:06 -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 72204-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  1 Mar 2009 18:02:03 -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 8186A632D14
	for <pgsql-admin@postgresql.org>; Sun,  1 Mar 2009 18:02:03 -0400 (AST)
Received: from [192.168.77.34] (p4FC19606.dip0.t-ipconnect.de
	[::ffff:79.193.150.6])
	(AUTH: CRAM-MD5 markus@bluegap.ch, TLS: TLSv1/SSLv3, 256bits,
	AES256-SHA)
	by shaykin.bluegap.ch with esmtp; Sun, 01 Mar 2009 23:01:59 +0100
	id 000000000173C003.0000000049AB05D7.000032E5
Message-ID: <49AB05D4.8060309@bluegap.ch>
Date: Sun, 01 Mar 2009 23:01:56 +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>
In-Reply-To: <1168.71.208.251.23.1235918386.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/7
X-Sequence-Number: 31507

Hi Bryan,

Bryan Keith wrote:
> After thinking about this a little more, I realize that the problem for me
> is not that the upgrade didn't go well.  It's that I can't access my data
> on 8.2.

Well, yeah, if your Postgres 8.2 doesn't even start up, you cannot dump
the data from it. And pg_upgradecluster does not much more that a dump
restore cycle.

> If
> I can access the data on 8,2, that'd be great, too, and then I can worry
> about upgrading.

That sounds like a reasonable approach, yeah.

> How can I see it?  Why won't 8.2 start?  Note that I get no message at the
> prompt when trying to start 8.2.

Is the package postgresql-8.2 still installed? Or did the Ubuntu upgrade
automatically deinstall that? What does the log in
/var/log/postgresql/8.2/... say?

Regards

Markus Wanner