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