Re: postgres 8.2 doesn't start after ubuntu upgrade

From: "Bryan Keith" <bryan(at)ideotrope(dot)org>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Daniel J(dot) Summers" <daniel(at)djs-consulting(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
Date: 2009-03-01 04:41:18
Message-ID: 1237.71.208.251.23.1235882478.squirrel@ideotrope.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers
> <daniel(at)djs-consulting(dot)com> wrote:
>> Bryan Keith wrote:
>>>
>>> I can run 8.3 and see the dbs (the default ones only; not mine) with
>>> psql.
>>>
>>
>> I ran into this on an upgrade - however, I didn't do what I'm about to
>> describe, and I lost all my data. Luckily, it wasn't the only place
>> where it
>> was, but there was some development stuff that I had to reaccomplish.
>> Once I
>> had lost it, I discovered the command below...
>>
>> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lukas 2009-03-01 08:37:26 Re: Postgesql and SSL
Previous Message Scott Marlowe 2009-03-01 03:56:43 Re: postgres 8.2 doesn't start after ubuntu upgrade