Re: RPM Package of PostgreSQL 9.6.1 for CentOS - Mailing list pgsql-general

From John R Pierce
Subject Re: RPM Package of PostgreSQL 9.6.1 for CentOS
Date
Msg-id 39d9f72d-e94a-b5a1-87da-3af9ae884f7d@hogranch.com
Whole thread Raw
In response to RPM Package of PostgreSQL 9.6.1 for CentOS  ("Igal @ Lucee.org" <igal@lucee.org>)
List pgsql-general
On 10/31/2016 11:52 AM, Igal @ Lucee.org wrote:
>
> I see the package for 9.6.0 at
> https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/
>
>     pgdg-centos96-9.6-3.noarch.rpm
>
> Should there be one for 9.6.1?
>

thats the yum.repos.d stuff for the 9.6 repository, it doesn't need
updating for sub releases like 9.6.1

> When I try to install postgresql96-9.6.1-1PGDG.rhel7.x86_64.rpm I get
> dependency errors, so I'm looking for a package like the one above for
> 9.6.1.

could you be more specific?   like, the actual error output from the yum
install ?

# yum install
https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm
Loaded plugins: fastestmirror
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
pgdg-centos96-9.6-3.noarch.rpm | 4.7 kB  00:00:00
Examining /var/tmp/yum-root-bcKtJG/pgdg-centos96-9.6-3.noarch.rpm:
pgdg-centos96-9.6-3.noarch
Marking /var/tmp/yum-root-bcKtJG/pgdg-centos96-9.6-3.noarch.rpm to be
installed
Resolving Dependencies
--> Running transaction check
---> Package pgdg-centos96.noarch 0:9.6-3 will be installed
--> Finished Dependency Resolution

Dependencies Resolved


==================================================================================================================================================================
  Package Arch                            Version
Repository                                            Size

==================================================================================================================================================================
Installing:
  pgdg-centos96 noarch                          9.6-3
/pgdg-centos96-9.6-3.noarch                          2.7 k

Transaction Summary

==================================================================================================================================================================
Install  1 Package

Total size: 2.7 k
Installed size: 2.7 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
   Installing : pgdg-centos96-9.6-3.noarch 1/1
   Verifying  : pgdg-centos96-9.6-3.noarch 1/1

Installed:
   pgdg-centos96.noarch 0:9.6-3

Complete!


# yum install postgresql96-server
Loaded plugins: fastestmirror
base | 3.6 kB  00:00:00
epel/x86_64/metalink |  13 kB  00:00:00
epel | 4.3 kB  00:00:00
extras | 3.4 kB  00:00:00
pgdg96 | 4.1 kB  00:00:00
updates | 3.4 kB  00:00:00
(1/7): epel/x86_64/group_gz | 170 kB  00:00:00
(2/7): epel/x86_64/updateinfo | 669 kB  00:00:00
(3/7): epel/x86_64/primary_db | 4.3 MB  00:00:00
(4/7): extras/7/x86_64/primary_db | 166 kB  00:00:00
(5/7): pgdg96/7/x86_64/group_gz |  333 B  00:00:00
(6/7): updates/7/x86_64/primary_db | 9.1 MB  00:00:00
(7/7): pgdg96/7/x86_64/primary_db | 119 kB  00:00:00
Loading mirror speeds from cached hostfile
  * base: repos.lax.quadranet.com
  * epel: mirror.sfo12.us.leaseweb.net
  * extras: mirrors.unifiedlayer.com
  * updates: mirrors.ocf.berkeley.edu
Resolving Dependencies
--> Running transaction check
---> Package postgresql96-server.x86_64 0:9.6.1-1PGDG.rhel7 will be
installed
--> Processing Dependency: postgresql96-libs(x86-64) = 9.6.1-1PGDG.rhel7
for package: postgresql96-server-9.6.1-1PGDG.rhel7.x86_64
--> Processing Dependency: postgresql96(x86-64) = 9.6.1-1PGDG.rhel7 for
package: postgresql96-server-9.6.1-1PGDG.rhel7.x86_64
--> Running transaction check
---> Package postgresql96.x86_64 0:9.6.1-1PGDG.rhel7 will be installed
---> Package postgresql96-libs.x86_64 0:9.6.1-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved


==================================================================================================================================================================
  Package Arch Version Repository                       Size

==================================================================================================================================================================
Installing:
  postgresql96-server x86_64 9.6.1-1PGDG.rhel7
pgdg96                          4.2 M
Installing for dependencies:
  postgresql96 x86_64 9.6.1-1PGDG.rhel7 pgdg96
1.3 M
  postgresql96-libs x86_64 9.6.1-1PGDG.rhel7
pgdg96                          308 k

Transaction Summary

==================================================================================================================================================================
Install  1 Package (+2 Dependent packages)

Total download size: 5.9 M
Installed size: 25 M
Is this ok [y/d/N]: y
Downloading packages:
(1/3): postgresql96-libs-9.6.1-1PGDG.rhel7.x86_64.rpm | 308 kB  00:00:02
(2/3): postgresql96-server-9.6.1-1PGDG.rhel7.x86_64.rpm | 4.2 MB  00:00:01
(3/3): postgresql96-9.6.1-1PGDG.rhel7.x86_64.rpm | 1.3 MB  00:00:09

------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 614 kB/s | 5.9 MB  00:00:09
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
   Installing : postgresql96-libs-9.6.1-1PGDG.rhel7.x86_64 1/3
   Installing : postgresql96-9.6.1-1PGDG.rhel7.x86_64 2/3
   Installing : postgresql96-server-9.6.1-1PGDG.rhel7.x86_64 3/3
   Verifying  : postgresql96-server-9.6.1-1PGDG.rhel7.x86_64 1/3
   Verifying  : postgresql96-9.6.1-1PGDG.rhel7.x86_64 2/3
   Verifying  : postgresql96-libs-9.6.1-1PGDG.rhel7.x86_64 3/3

Installed:
   postgresql96-server.x86_64 0:9.6.1-1PGDG.rhel7

Dependency Installed:
   postgresql96.x86_64 0:9.6.1-1PGDG.rhel7 postgresql96-libs.x86_64
0:9.6.1-1PGDG.rhel7

Complete!


--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: "Igal @ Lucee.org"
Date:
Subject: RPM Package of PostgreSQL 9.6.1 for CentOS
Next
From: Melvin Davidson
Date:
Subject: Re: Way to quickly detect if database tables/columns/etc. were modified?