Re: 9.2 on Debian 5.0 (Lenny)?

Re: Colin 't Hart 2017-02-15 <CAMon-aTFqvdtetyD5XX6PFZ8d6MC8WGXBObaqyano80YsxKs0w(at)mail(dot)gmail(dot)com>
> Perusing https://apt.postgresql.org/pub/repos/apt/dists/lenny-pgdg/
> seems to indicate that 9.2 should be available, but trying to install
> it results in errors:
>
> colin(at)lb-replica:~$ sudo apt-get install postgresql-9.2
> Package postgresql-9.2 is not available, but is referred to by another package.
>
> colin(at)lb-replica:~$ sudo apt-get install postgresql
> The following packages have unmet dependencies:
> postgresql: Depends: postgresql-9.2 but it is not installable

Hi,

lenny was never really supported on apt.postgresql.org. The package
traces that you can find there are from early attempts of importing
existing packages from elsewhere as you can see from the 9.1 version
there:

postgresql-9.1 | 9.1.2-4~bpo50+1 | lenny-pgdg | amd64, i386, source

That's also the newest 9.1 version for lenny you'll see on
http://archive.debian.org/backports.org/pool/main/p/postgresql-9.1/

(I'm not going to touch it, but the real fix here is to simply remove
the lenny-pgdg suite on apt.postgresql.org.)

> I can just upgrade to 9.1 but it would be very nice to upgrade as far
> as we can without upgrading the OS.

I wouldn't recommend upgrading to 9.1.2, it is missing 22 rounds of
minor updates (current and last is 9.1.24).

I'm afraid you'll really need to upgrade that box. Maybe you can leave
the application (which is often the real reason for not being able to
upgrade) around there, and install a brand new PG version on a
different host and connect over there?

Christoph