postgresql-apt-repo-pulling-in-15-not-sure-why
#750
- 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