pgcenter installation also upgrade postgresql version

[yinan8128]

Describe the bug We installed pgcenter but also upgraded postgresql from 11.4 to 11.18, please check the steps in "To Reproduce"

Environment Describe the environment where the bug occurred.

• OS: CentOS Linux 7 (Core)
• pgCenter Version 0.4.0
• pgCenter installation method: yum installation
• PostgreSQL Version 11.4

To Reproduce yum list installed | grep postgresql11 postgresql11.x86_64 11.4-1PGDG.rhel7 @pgdg postgresql11-contrib.x86_64 11.4-1PGDG.rhel7 @pgdg postgresql11-libs.x86_64 11.4-1PGDG.rhel7 @pgdg postgresql11-server.x86_64 11.4-1PGDG.rhel7 @pgdg

--enable the repo which contain pgcenter package(from https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-7.2-x86_64/) vim /etc/yum.repos.d/pgdg-common-centos.repo

[pgdg-common] name=PostgreSQL common rpm repo - $basearch baseurl=https://ch-repo.adc.corp.abc.com/public/pgdg-common/ gpgcheck=0 enabled=1

--enable the repo which contain postgresql package vim /etc/yum.repos.d/pgdg-centos.repo

[pgdg] name=PostgreSQL 11 rpm repo - $basearch baseurl=https://ch-repo.adc.corp.abc.com/public/pgdg/11/ gpgcheck=0 enabled=1

yum list pgcenter Available Packages pgcenter.x86_64 0.4.0-2.rhel7 pgdg-common

yum install pgcenter [24/1939] pgdg | 2.9 kB 00:00:00 pgdg-aux | 2.9 kB 00:00:00 pgdg-common | 2.9 kB 00:00:00 Resolving Dependencies --> Running transaction check ---> Package pgcenter.x86_64 0:0.4.0-2.rhel7 will be installed --> Processing Dependency: libpq5 >= 10.0 for package: pgcenter-0.4.0-2.rhel7.x86_64 --> Running transaction check ---> Package postgresql11-libs.x86_64 0:11.4-1PGDG.rhel7 will be updated --> Processing Dependency: postgresql11-libs(x86-64) = 11.4-1PGDG.rhel7 for package: postgresql11-11.4-1PGDG.rhel7.x86_64 --> Processing Dependency: postgresql11-libs(x86-64) = 11.4-1PGDG.rhel7 for package: postgresql11-server-11.4-1PGDG.rhel7.x86_64 --> Processing Dependency: postgresql11-libs(x86-64) = 11.4-1PGDG.rhel7 for package: postgresql11-contrib-11.4-1PGDG.rhel7.x86_64 ---> Package postgresql11-libs.x86_64 0:11.18-1PGDG.rhel7 will be an update --> Running transaction check ---> Package postgresql11.x86_64 0:11.4-1PGDG.rhel7 will be updated ---> Package postgresql11.x86_64 0:11.18-1PGDG.rhel7 will be an update ---> Package postgresql11-contrib.x86_64 0:11.4-1PGDG.rhel7 will be updated ---> Package postgresql11-contrib.x86_64 0:11.18-1PGDG.rhel7 will be an update ---> Package postgresql11-server.x86_64 0:11.4-1PGDG.rhel7 will be updated ---> Package postgresql11-server.x86_64 0:11.18-1PGDG.rhel7 will be an update --> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================================================================================================================$ Package Arch Version Repository Size =======================================================================================================================================================================================================$ Installing: pgcenter x86_64 0.4.0-2.rhel7 pgdg-common 51 k Updating for dependencies: postgresql11 x86_64 11.18-1PGDG.rhel7 pgdg 1.7 M postgresql11-contrib x86_64 11.18-1PGDG.rhel7 pgdg 615 k postgresql11-libs x86_64 11.18-1PGDG.rhel7 pgdg 369 k postgresql11-server x86_64 11.18-1PGDG.rhel7 pgdg 4.7 M

Transaction Summary =======================================================================================================================================================================================================$ Install 1 Package Upgrade ( 4 Dependent packages)

Total download size: 7.4 M Is this ok [y/d/N]: y Downloading packages: Delta RPMs disabled because /usr/bin/applydeltarpm not installed. (1/5): pgcenter-0.4.0-2.rhel7.x86_64.rpm | 51 kB 00:00:00 (2/5): postgresql11-contrib-11.18-1PGDG.rhel7.x86_64.rpm | 615 kB 00:00:00 (3/5): postgresql11-libs-11.18-1PGDG.rhel7.x86_64.rpm | 369 kB 00:00:00 (4/5): postgresql11-11.18-1PGDG.rhel7.x86_64.rpm | 1.7 MB 00:00:00 (5/5): postgresql11-server-11.18-1PGDG.rhel7.x86_64.rpm | 4.7 MB 00:00:01

Total 3.8 MB/s | 7.4 MB 00:00:01 Running transaction check Running transaction test Transaction test succeeded Running transaction Updating : postgresql11-libs-11.18-1PGDG.rhel7.x86_64 1/9 Updating : postgresql11-11.18-1PGDG.rhel7.x86_64 2/9 Updating : postgresql11-server-11.18-1PGDG.rhel7.x86_64 3/9 Updating : postgresql11-contrib-11.18-1PGDG.rhel7.x86_64 4/9 Installing : pgcenter-0.4.0-2.rhel7.x86_64 5/9 Cleanup : postgresql11-server-11.4-1PGDG.rhel7.x86_64 6/9 Cleanup : postgresql11-contrib-11.4-1PGDG.rhel7.x86_64 7/9 Cleanup : postgresql11-11.4-1PGDG.rhel7.x86_64 8/9 Cleanup : postgresql11-libs-11.4-1PGDG.rhel7.x86_64 9/9 Verifying : postgresql11-contrib-11.18-1PGDG.rhel7.x86_64 1/9 Verifying : postgresql11-11.18-1PGDG.rhel7.x86_64 2/9 Verifying : postgresql11-libs-11.18-1PGDG.rhel7.x86_64 3/9 Verifying : postgresql11-server-11.18-1PGDG.rhel7.x86_64 4/9 Verifying : pgcenter-0.4.0-2.rhel7.x86_64 5/9 Verifying : postgresql11-contrib-11.4-1PGDG.rhel7.x86_64 6/9 Verifying : postgresql11-libs-11.4-1PGDG.rhel7.x86_64 7/9 Verifying : postgresql11-server-11.4-1PGDG.rhel7.x86_64 8/9 Verifying : postgresql11-11.4-1PGDG.rhel7.x86_64 9/9

Installed: pgcenter.x86_64 0:0.4.0-2.rhel7

Dependency Updated: postgresql11.x86_64 0:11.18-1PGDG.rhel7 postgresql11-contrib.x86_64 0:11.18-1PGDG.rhel7 postgresql11-libs.x86_64 0:11.18-1PGDG.rhel7 postgresql11-server.x86_64 0:11.18-1PGDG.rhel7

Complete!

yum list installed | grep postgresql11 postgresql11.x86_64 11.18-1PGDG.rhel7 @pgdg postgresql11-contrib.x86_64 11.18-1PGDG.rhel7 @pgdg postgresql11-libs.x86_64 11.18-1PGDG.rhel7 @pgdg postgresql11-server.x86_64 11.18-1PGDG.rhel7 @pgdg

Expected behavior pgcenter installation no postgresql version upgrade

[lesovsky]

pgcenter is not a dependency of postgresql packages and should be upgraded explicitly. Also PGDG repo contains old version of pgcenter and i recommend you download package from releases page.

[cloud-66]

it looks like pgcenter.x86_64 depends on libpq5 libpq5 in postgresql11-libs.x86_64 postgresql11-libs.x86_64 depends on other postgresql11 packages