A 10.5-2 version of postgresql that is coming from the
deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main
repository has a problem, and I would like to return to the 10.4 version I know to be working the way I want.
an apt-cache madison postgresql-10 returns me these informations atm :
postgresql-10 | 10.5-2.pgdg90+1 | http://apt.postgresql.org/pub/repos/apt stretch-pgdg/main amd64 Packages
postgresql-10 | 10.5-2.pgdg90+1 | http://apt.postgresql.org/pub/repos/apt stretch-pgdg/main Sources
How can I find the previous packages version(s) existing for 10.4 ?
When I try to use a version number I found somewhere (on chocolatey website : I had no clue about how to search and was a bit lost), it didn't succeed :
sudo apt-get install postgresql-10=10.4.0.20180721
E: Version '10.4.0.20180721' for 'postgresql-10' was not found
Going to the postgresql repository, http://apt.postgresql.org/pub/repos/apt/dists/stretch-pgdg/, I didn't found a clue about how to get any previous version.
More generally, what is the way, through command line and aptitude commands, to list what previous versions can be installed for a package ?
Is there, for example, a standard that set another location for previous versions, like an archive repository I should always find in the form http://../archive/../, or something else ?
Thanks !
apt-cache showpkg <package-name> will list all the available versions
Either of these
apt install <package-name>=<package-version-number>apt -t=<target release> install <package-name>apt-mark hold <package-name> will prevent automatic upgrades
postgresql is now on version 11 is available from the main website.
On github, next to "make a pull request" click on master, change selection to '10 stable', then make a pull request. You'll need to fix the bug if 10 stable is 10.5. If this isn't easy, you can compare code from 9.5 stable - only 1066 files that were altered and go through changing them. Stinks that they didn't actually keep tags for other versions.
Sources: https://askubuntu.com/questions/138284/how-to-downgrade-a-package-via-apt-get#138327
Edit: Don't forget to update before you check for the available packages.