You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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.
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
The text was updated successfully, but these errors were encountered: