Re: postgres 8.2 doesn't start after ubuntu upgrade - Mailing list pgsql-admin

From Bryan Keith
Subject Re: postgres 8.2 doesn't start after ubuntu upgrade
Date
Msg-id 2642.64.78.232.178.1236012911.squirrel@ideotrope.org
Whole thread Raw
In response to Re: postgres 8.2 doesn't start after ubuntu upgrade  ("Bryan Keith" <bryan@ideotrope.org>)
List pgsql-admin
>>> How do I install postgres 8.2?  I think I installed 8.2 with something
>>> like sudo apt-get install postgresql, but that will install 8.3 now, I
>>> think.
>>
>> Try: sudo apt-get install postgresql-8.2
>>
>> I'm not sure about Ubuntu. Probably 8.2 isn't included in Intrepid
>> anymore. (packages.ubuntu.com is currently not responding) (Why don't
>> you stay at a LTS ubuntu version for a database server?)
>>
>> If that's the case, try adding the Hardy Heron repository back to
>> /etc/apt/sources.list. If postgres-8.2 isn't available on Intrepid Ibex,
>> it then falls back to that from Hardy Heron.
>
> but I can't figure out what lines to add to /etc/apt/sources.list to find
> the repository.  I keep getting this error:
>
> $ sudo apt-get install postgresql-8.2
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Package postgresql-8.2 is not available, but is referred to by another
> package.
> This may mean that the package is missing, has been obsoleted, or
> is only available from another source
> E: Package postgresql-8.2 has no installation candidate
> $
>

OK, there's an extra step that I was missing.  Any changing the sources in
sources.list, I needed to run

[code]sudo apt-get update[/code]

Now I have postgres 8.2 installed, and I can see my old databases.  I'll
try the upgrading, backup, and all that, and let you know how it goes.

Thank you everyone for all the help.

Bryan



pgsql-admin by date:

Previous
From: Markus Wanner
Date:
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
Next
From: Carol Walter
Date:
Subject: Database in use?