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 1203.64.78.232.178.1236012176.squirrel@ideotrope.org
Whole thread Raw
In response to Re: postgres 8.2 doesn't start after ubuntu upgrade  (Markus Wanner <markus@bluegap.ch>)
Responses Re: postgres 8.2 doesn't start after ubuntu upgrade  (Markus Wanner <markus@bluegap.ch>)
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.

It looks to me like postgresql-8.2 is still available in the hardy
repositories:

http://packages.ubuntu.com/hardy/misc/postgresql-8.2

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
$

I even put the entire old (from hardy) file into sources.list, but that
didn't work.  sources.list looked like this at that point:

deb http://us.archive.ubuntu.com/ubuntu/ hardy main restricted
deb-src http://us.archive.ubuntu.com/ubuntu/ hardy main restricted

deb http://us.archive.ubuntu.com/ubuntu/ hardy-updates main restricted
deb-src http://us.archive.ubuntu.com/ubuntu/ hardy-updates main restricted

deb http://us.archive.ubuntu.com/ubuntu/ hardy universe
deb-src http://us.archive.ubuntu.com/ubuntu/ hardy universe
deb http://us.archive.ubuntu.com/ubuntu/ hardy-updates universe
deb-src http://us.archive.ubuntu.com/ubuntu/ hardy-updates universe

deb http://us.archive.ubuntu.com/ubuntu/ hardy multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ hardy multiverse
deb http://us.archive.ubuntu.com/ubuntu/ hardy-updates multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ hardy-updates multiverse

deb http://security.ubuntu.com/ubuntu hardy-security main restricted
deb-src http://security.ubuntu.com/ubuntu hardy-security main restricted
deb http://security.ubuntu.com/ubuntu hardy-security universe
deb-src http://security.ubuntu.com/ubuntu hardy-security universe
deb http://security.ubuntu.com/ubuntu hardy-security multiverse

Same error.  Any suggestions?

Bryan


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: getting 'full' names of functions?
Next
From: Markus Wanner
Date:
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade