From: Bryan Keith <bryan@ideotrope.org>
To: pgsql-admin@postgresql.org
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Daniel J. Summers <daniel@djs-consulting.com>
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
Date: Sun, 1 Mar 2009 07:39:46 -0700 (MST)
Message-ID: <1168.71.208.251.23.1235918386.squirrel@ideotrope.org> (raw)
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>
>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bryan@ideotrope.org, scott.marlowe@gmail.com, daniel@djs-consulting.com
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
In-Reply-To: <1168.71.208.251.23.1235918386.squirrel@ideotrope.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox