Thread: [pgsql-pkg-debian] 9.2 on Debian 5.0 (Lenny)?
Hi, I'm trying to upgrade an old machine we have currently on Debian 5.0 (Lenny) and PG 8.3 (yes, I know it's ancient, but the software is that good it just keeps on working without problems). 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@lb-replica:~$ sudo apt-get install postgresql-9.2 Reading package lists... Done Building dependency tree Reading state information... Done Package postgresql-9.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-9.2 has no installation candidate colin@lb-replica:~$ This is a different error than if the package is simply not available: colin@lb-replica:~$ sudo apt-get install postgresql-9.3 Reading package lists... Done Building dependency tree Reading state information... Done E: Couldn't find package postgresql-9.3 colin@lb-replica:~$ Trying to install just "postgresql" results in a similar error message: colin@lb-replica:~$ sudo apt-get install postgresql Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: postgresql: Depends: postgresql-9.2 but it is not installable E: Broken packages colin@lb-replica:~$ My relevant APT files are as follows: colin@lb-replica:~$ more /etc/apt/sources.list deb http://archive.debian.org/debian/ lenny main contrib non-free colin@lb-replica:~$ more /etc/apt/sources.list.d/pgdg.list deb http://apt.postgresql.org/pub/repos/apt/ lenny-pgdg main I can just upgrade to 9.1 but it would be very nice to upgrade as far as we can without upgrading the OS. Thanks! /Colin
Re: Colin 't Hart 2017-02-15 <CAMon-aTFqvdtetyD5XX6PFZ8d6MC8WGXBObaqyano80YsxKs0w@mail.gmail.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@lb-replica:~$ sudo apt-get install postgresql-9.2 > Package postgresql-9.2 is not available, but is referred to by another package. > > colin@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