Re: postgres 8.2 doesn't start after ubuntu upgrade

From: "Bryan Keith" <bryan(at)ideotrope(dot)org>
To: "Markus Wanner" <markus(at)bluegap(dot)ch>
Cc: pgsql-admin(at)postgresql(dot)org, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Daniel J(dot) Summers" <daniel(at)djs-consulting(dot)com>
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
Date: 2009-03-02 16:42:56
Message-ID: 1203.64.78.232.178.1236012176.squirrel@ideotrope.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Wanner 2009-03-02 16:52:42 Re: postgres 8.2 doesn't start after ubuntu upgrade
Previous Message Tom Lane 2009-03-02 15:07:57 Re: getting 'full' names of functions?