And the changelog is on 9.5.19
root@x:~# zcat /usr/share/doc/postgresql-9.5/changelog.Debian.gz | head
postgresql-9.5 (9.5.19-0ubuntu0.16.04.1) xenial-security; urgency=medium
* SECURITY UPDATE: New upstream release (LP: #1839058)
- Require schema qualification to cast to a temporary type when using
functional cast syntax (CVE-2019-10208)
- Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple
columns' types in one command. This fixes a regression introduced in the
most recent minor releases
- Details about these and many further changes can be found at: https://www.postgresql.org/docs/9.5/static/release-9-5-19.html
You listed:
postgresql-11 (11.2-1.pgdg14.04+1) trusty-pgdg
That never existed in the Ubuntu archive.
It is most likely that you installed from upstreams PPA at https://wiki.postgresql.org/wiki/Apt
They produce such versions and it most likely is a conflict or remainder of that.
You'd need to clear out all non-Ubuntu-Archive packages to resolve this, as it isn't a Ubuntu packager there isn't much Ubuntu can do about it :-/
Hi, at least as of today this seems to match well:
root@x:~# apt-cache policy postgresql-9.5 0ubuntu0. 16.04.1 0ubuntu0. 16.04.1 0ubuntu0. 16.04.1 500 archive. ubuntu. com/ubuntu xenial-updates/main amd64 Packages security. ubuntu. com/ubuntu xenial- security/ main amd64 Packages dpkg/status archive. ubuntu. com/ubuntu xenial/main amd64 Packages
postgresql-9.5:
Installed: 9.5.19-
Candidate: 9.5.19-
Version table:
*** 9.5.19-
500 http://
500 http://
100 /var/lib/
9.5.2-1 500
500 http://
And the changelog is on 9.5.19 doc/postgresql- 9.5/changelog. Debian. gz | head 0ubuntu0. 16.04.1) xenial-security; urgency=medium
root@x:~# zcat /usr/share/
postgresql-9.5 (9.5.19-
* SECURITY UPDATE: New upstream release (LP: #1839058) /www.postgresql .org/docs/ 9.5/static/ release- 9-5-19. html
- Require schema qualification to cast to a temporary type when using
functional cast syntax (CVE-2019-10208)
- Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple
columns' types in one command. This fixes a regression introduced in the
most recent minor releases
- Details about these and many further changes can be found at:
https:/
You listed: pgdg14. 04+1) trusty-pgdg
postgresql-11 (11.2-1.
That never existed in the Ubuntu archive. /wiki.postgresq l.org/wiki/ Apt
It is most likely that you installed from upstreams PPA at https:/
They produce such versions and it most likely is a conflict or remainder of that.
You'd need to clear out all non-Ubuntu-Archive packages to resolve this, as it isn't a Ubuntu packager there isn't much Ubuntu can do about it :-/