postgresql-apt-repo-pulling-in-15-not-sure-why

#750
Raw
Author
Anonymous
Created
May 8, 2023, 6:45 p.m.
Expires
Never
Size
3.3 KB
Hits
133
Syntax
None
Private
✗ No
ubuntu@esg-rc:~$ dpkg -l | grep ^ii | grep -E 'libpq|postgres'
ii  libpq5:amd64                       14.7-0ubuntu0.22.04.1                   amd64        PostgreSQL C client library
ii  postgresql-14                      14.7-0ubuntu0.22.04.1                   amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-client-14               14.7-0ubuntu0.22.04.1                   amd64        front-end programs for PostgreSQL 14
ii  postgresql-client-common           238                                     all          manager for multiple PostgreSQL client versions
ii  postgresql-common                  238                                     all          PostgreSQL database-cluster manager
ii  postgresql-contrib                 14+238                                  all          additional facilities for PostgreSQL (supported version)
ubuntu@esg-rc:~$ sudo apt dist-upgrade --dry-run
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Calculating upgrade... Done
The following NEW packages will be installed:
  postgresql-15 postgresql-client-15
The following packages will be upgraded:
  libpq5 postgresql-14 postgresql-client-14 postgresql-client-common postgresql-common postgresql-contrib
6 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Inst postgresql-common [238] (248.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [all]) []
Inst postgresql-client-common [238] (248.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [all])
Inst libpq5 [14.7-0ubuntu0.22.04.1] (15.2-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Inst postgresql-client-14 [14.7-0ubuntu0.22.04.1] (14.7-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Inst postgresql-14 [14.7-0ubuntu0.22.04.1] (14.7-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Inst postgresql-client-15 (15.2-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Inst postgresql-15 (15.2-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Inst postgresql-contrib [14+238] (15+248.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [all])
Conf postgresql-common (248.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [all])
Conf postgresql-client-common (248.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [all])
Conf libpq5 (15.2-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Conf postgresql-client-14 (14.7-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Conf postgresql-14 (14.7-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Conf postgresql-client-15 (15.2-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Conf postgresql-15 (15.2-1.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [amd64])
Conf postgresql-contrib (15+248.pgdg22.04+1 PostgreSQL for Debian/Ubuntu repository:jammy-pgdg [all])
ubuntu@esg-rc:~$ dpkg -l | grep ^ii > /tmp/dpkg.txt
ubuntu@esg-rc:~$ apt-cache rdepends postgresql-15 | awk 'NR > 2 { print $1 }' | xargs -I{} grep -E '^ii[ \t]+{}[ \t]' /tmp/dpkg.txt 
ubuntu@esg-rc:~$ apt-cache rdepends postgresql-client-15 | awk 'NR > 2 { print $1 }' | xargs -I{} grep -E '^ii[ \t]+{}[ \t]' /tmp/dpkg.txt