> On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers
> <daniel@djs-consulting.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