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
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 |