Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D57E26354FD
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  1 Mar 2009 10:39:51 -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 17756-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  1 Mar 2009 10:39:48 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.ideotrope.org (ideotrope.org [209.237.247.148])
	by mail.postgresql.org (Postfix) with ESMTP id EB20D6354F8
	for <pgsql-admin@postgresql.org>; Sun,  1 Mar 2009 10:39:48 -0400 (AST)
Received: from ideotrope.org (localhost [127.0.0.1])
	by mail.ideotrope.org (Postfix) with ESMTP id 2E41F33D13;
	Sun,  1 Mar 2009 06:39:46 -0800 (PST)
Received: from 71.208.251.23 (SquirrelMail authenticated user bryan)
	by ideotrope.org with HTTP; Sun, 1 Mar 2009 07:39:46 -0700 (MST)
Message-ID: <1168.71.208.251.23.1235918386.squirrel@ideotrope.org>
In-Reply-To: <1237.71.208.251.23.1235882478.squirrel@ideotrope.org>
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>
Date: Sun, 1 Mar 2009 07:39:46 -0700 (MST)
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
From: "Bryan Keith" <bryan@ideotrope.org>
To: pgsql-admin@postgresql.org
Cc: "Scott Marlowe" <scott.marlowe@gmail.com>,
	"Daniel J. Summers" <daniel@djs-consulting.com>
User-Agent: SquirrelMail/1.4.9a
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
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/5
X-Sequence-Number: 31505

>> On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers
>> <daniel@djs-consulting.com> wrote:
>>>
>>> The command you're looking for is pg_upgradecluster. There's a
>>> description
>>> of it at
>>> http://manpages.ubuntu.com/manpages/hardy/man8/pg_upgradecluster.8.html
>>> . I
>>> believe the only time you'll need this is if you change the major or
>>> minor
>>> version - for 8.3.5 to 8.3.6, for example, I believe there's no upgrade
>>> required.
>>
>
> This sounds promising.  However, how do I start the cluster?  Here's what
> I did.  Remember that trying to start 8.2 doesn't do anything.
>
> $ /etc/init.d/postgresql-8.2 start
> $ pg_upgradecluster 8.2 main
> Error: specified cluster is not running
> $ ls /etc/postgresql/8.2
> main
> $
>
> Am I doing something wrong here?
>
> Bryan
>

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.  If upgrading the cluster allows me to access the data, great.  If
I can access the data on 8,2, that'd be great, too, and then I can worry
about upgrading.  It looks to me like the data is still there:

$ du -shc /var/lib/postgresql/8.2/*
308M        /var/lib/postgresql/8.2/main
308M        total
$ du -shc /var/lib/postgresql/8.3/*
30M        /var/lib/postgresql/8.3/main
30M        total
$

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.

Bryan