Selasa, 25 Mei 2021

POSTGRESQL-ppc64le

 

FOR RHEL 8 - PPC64LE

https://yum.postgresql.org/news/rhel8-ppc64le-postgresql-repo-available/
https://yum.postgresql.org/packages/#pg96

PostgreSQL RPM repo now has support for RHEL 8 - ppc64le, including all of the supported PostgreSQL versions as of today.

To use the repo and install PostgreSQL on this platform, please follow these steps:

Install the repo RPM first:

dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-ppc64le/pgdg-redhat-repo-latest.noarch.rpm

Disable PostgreSQL module of the OS (so that we can install our packages)

dnf -qy module disable postgresql

Install PostgreSQL as usual (change 13 for the PostgreSQL version that you want to install):

dnf -y install postgresql13-server postgresql13-contrib

Initialize the cluster:

postgresql-13-setup initdb

Start the new instance:

systemctl enable --now postgresql-13

Done!

-----------------------------------------------------------------------------


[root@hdpmaster yum.repos.d]# yum-config-manager --disable redhat
[root@hdpmaster yum.repos.d]# yum install postgresql12-server postgresql12-contrib
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
pgdg-common                                                                                                                                      | 2.9 kB  00:00:00      
pgdg10                                                                                                                                           | 3.6 kB  00:00:00      
pgdg11                                                                                                                                           | 3.6 kB  00:00:00      
pgdg12                                                                                                                                           | 3.6 kB  00:00:00      
pgdg13                                                                                                                                           | 3.6 kB  00:00:00      
pgdg95                                                                                                                                           | 3.6 kB  00:00:00      
pgdg96                                                                                                                                           | 3.6 kB  00:00:00      
(1/13): pgdg11/7Server/ppc64le/group_gz                                                                                                          |  245 B  00:00:01      
(2/13): pgdg12/7Server/ppc64le/group_gz                                                                                                          |  245 B  00:00:00      
(3/13): pgdg10/7Server/ppc64le/group_gz                                                                                                          |  245 B  00:00:01      
(4/13): pgdg11/7Server/ppc64le/primary_db                                                                                                        |  75 kB  00:00:01      
(5/13): pgdg13/7Server/ppc64le/group_gz                                                                                                          |  246 B  00:00:00      
(6/13): pgdg13/7Server/ppc64le/primary_db                                                                                                        |  23 kB  00:00:00      
(7/13): pgdg12/7Server/ppc64le/primary_db                                                                                                        |  60 kB  00:00:00      
(8/13): pgdg95/7Server/ppc64le/group_gz                                                                                                          |  249 B  00:00:00      
(9/13): pgdg96/7Server/ppc64le/group_gz                                                                                                          |  249 B  00:00:00      
(10/13): pgdg95/7Server/ppc64le/primary_db                                                                                                       |  86 kB  00:00:00      
(11/13): pgdg10/7Server/ppc64le/primary_db                                                                                                       |  77 kB  00:00:02      
(12/13): pgdg-common/7Server/ppc64le/primary_db                                                                                                  | 104 kB  00:00:03      
(13/13): pgdg96/7Server/ppc64le/primary_db                                                                                                       |  90 kB  00:00:01      
Resolving Dependencies
--> Running transaction check
---> Package postgresql12-contrib.ppc64le 0:12.7-1PGDG.rhel7 will be installed
--> Processing Dependency: postgresql12-libs(ppc-64) = 12.7-1PGDG.rhel7 for package: postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le
--> Processing Dependency: postgresql12(ppc-64) = 12.7-1PGDG.rhel7 for package: postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le
---> Package postgresql12-server.ppc64le 0:12.7-1PGDG.rhel7 will be installed
--> Running transaction check
---> Package postgresql12.ppc64le 0:12.7-1PGDG.rhel7 will be installed
---> Package postgresql12-libs.ppc64le 0:12.7-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package                                         Arch                               Version                                     Repository                         Size
========================================================================================================================================================================
Installing:
postgresql12-contrib                            ppc64le                            12.7-1PGDG.rhel7                            pgdg12                            709 k
postgresql12-server                             ppc64le                            12.7-1PGDG.rhel7                            pgdg12                            5.8 M
Installing for dependencies:
postgresql12                                    ppc64le                            12.7-1PGDG.rhel7                            pgdg12                            1.8 M
postgresql12-libs                               ppc64le                            12.7-1PGDG.rhel7                            pgdg12                            452 k

Transaction Summary
========================================================================================================================================================================
Install  2 Packages (+2 Dependent packages)

Total download size: 8.7 M
Installed size: 43 M
Is this ok [y/d/N]: n
Exiting on user command
Your transaction was saved, rerun it with:
yum load-transaction /tmp/yum_save_tx.2021-05-25.16-36.F07sLn.yumtx
[root@hdpmaster yum.repos.d]# yum install postgresql13-server postgresql13-contrib  
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Resolving Dependencies
--> Running transaction check
---> Package postgresql13-contrib.ppc64le 0:13.3-1PGDG.rhel7 will be installed
--> Processing Dependency: postgresql13-libs(ppc-64) = 13.3-1PGDG.rhel7 for package: postgresql13-contrib-13.3-1PGDG.rhel7.ppc64le
--> Processing Dependency: postgresql13(ppc-64) = 13.3-1PGDG.rhel7 for package: postgresql13-contrib-13.3-1PGDG.rhel7.ppc64le
--> Processing Dependency: advance-toolchain-at10.0-runtime for package: postgresql13-contrib-13.3-1PGDG.rhel7.ppc64le
---> Package postgresql13-server.ppc64le 0:13.3-1PGDG.rhel7 will be installed
--> Processing Dependency: advance-toolchain-at10.0-runtime for package: postgresql13-server-13.3-1PGDG.rhel7.ppc64le
--> Running transaction check
---> Package postgresql13.ppc64le 0:13.3-1PGDG.rhel7 will be installed
---> Package postgresql13-contrib.ppc64le 0:13.3-1PGDG.rhel7 will be installed
--> Processing Dependency: advance-toolchain-at10.0-runtime for package: postgresql13-contrib-13.3-1PGDG.rhel7.ppc64le
---> Package postgresql13-libs.ppc64le 0:13.3-1PGDG.rhel7 will be installed
--> Processing Dependency: advance-toolchain-at10.0-runtime for package: postgresql13-libs-13.3-1PGDG.rhel7.ppc64le
---> Package postgresql13-server.ppc64le 0:13.3-1PGDG.rhel7 will be installed
--> Processing Dependency: advance-toolchain-at10.0-runtime for package: postgresql13-server-13.3-1PGDG.rhel7.ppc64le
--> Finished Dependency Resolution
Error: Package: postgresql13-libs-13.3-1PGDG.rhel7.ppc64le (pgdg13)
          Requires: advance-toolchain-at10.0-runtime
Error: Package: postgresql13-server-13.3-1PGDG.rhel7.ppc64le (pgdg13)
          Requires: advance-toolchain-at10.0-runtime
Error: Package: postgresql13-contrib-13.3-1PGDG.rhel7.ppc64le (pgdg13)
          Requires: advance-toolchain-at10.0-runtime
**********************************************************************
yum can be configured to try to resolve such errors by temporarily enabling
disabled repos and searching for missing dependencies.
To enable this functionality please set 'notify_only=0' in /etc/yum/pluginconf.d/search-disabled-repos.conf
**********************************************************************

Error: Package: postgresql13-libs-13.3-1PGDG.rhel7.ppc64le (pgdg13)
          Requires: advance-toolchain-at10.0-runtime
Error: Package: postgresql13-server-13.3-1PGDG.rhel7.ppc64le (pgdg13)
          Requires: advance-toolchain-at10.0-runtime
Error: Package: postgresql13-contrib-13.3-1PGDG.rhel7.ppc64le (pgdg13)
          Requires: advance-toolchain-at10.0-runtime
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
[root@hdpmaster yum.repos.d]# yum install postgresql12-server postgresql12-contrib
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Resolving Dependencies
--> Running transaction check
---> Package postgresql12-contrib.ppc64le 0:12.7-1PGDG.rhel7 will be installed
--> Processing Dependency: postgresql12-libs(ppc-64) = 12.7-1PGDG.rhel7 for package: postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le
--> Processing Dependency: postgresql12(ppc-64) = 12.7-1PGDG.rhel7 for package: postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le
---> Package postgresql12-server.ppc64le 0:12.7-1PGDG.rhel7 will be installed
--> Running transaction check
---> Package postgresql12.ppc64le 0:12.7-1PGDG.rhel7 will be installed
---> Package postgresql12-libs.ppc64le 0:12.7-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package                                         Arch                               Version                                     Repository                         Size
========================================================================================================================================================================
Installing:
postgresql12-contrib                            ppc64le                            12.7-1PGDG.rhel7                            pgdg12                            709 k
postgresql12-server                             ppc64le                            12.7-1PGDG.rhel7                            pgdg12                            5.8 M
Installing for dependencies:
postgresql12                                    ppc64le                            12.7-1PGDG.rhel7                            pgdg12                            1.8 M
postgresql12-libs                               ppc64le                            12.7-1PGDG.rhel7                            pgdg12                            452 k

Transaction Summary
========================================================================================================================================================================
Install  2 Packages (+2 Dependent packages)

Total download size: 8.7 M
Installed size: 43 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/ppc64le/7Server/pgdg12/packages/postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY0:16 ETA  
Public key for postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le.rpm is not installed
(1/4): postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le.rpm                                                                                         | 709 kB  00:00:02      
(2/4): postgresql12-libs-12.7-1PGDG.rhel7.ppc64le.rpm                                                                                            | 452 kB  00:00:00      
(3/4): postgresql12-12.7-1PGDG.rhel7.ppc64le.rpm                                                                                                 | 1.8 MB  00:00:02      
(4/4): postgresql12-server-12.7-1PGDG.rhel7.ppc64le.rpm                                                                                          | 5.8 MB  00:00:04      
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                   1.3 MB/s | 8.7 MB  00:00:06      
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Importing GPG key 0x442DF0F8:
Userid     : "PostgreSQL RPM Building Project <pgsqlrpms-hackers@pgfoundry.org>"
Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
Package    : pgdg-redhat-repo-42.0-14.noarch (@/pgdg-redhat-repo-latest.noarch)
From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing : postgresql12-libs-12.7-1PGDG.rhel7.ppc64le                                                                                                           1/4  
 Installing : postgresql12-12.7-1PGDG.rhel7.ppc64le                                                                                                                2/4  
 Installing : postgresql12-server-12.7-1PGDG.rhel7.ppc64le                                                                                                         3/4  
 Installing : postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le                                                                                                        4/4  
 Verifying  : postgresql12-contrib-12.7-1PGDG.rhel7.ppc64le                                                                                                        1/4  
 Verifying  : postgresql12-12.7-1PGDG.rhel7.ppc64le                                                                                                                2/4  
 Verifying  : postgresql12-libs-12.7-1PGDG.rhel7.ppc64le                                                                                                           3/4  
 Verifying  : postgresql12-server-12.7-1PGDG.rhel7.ppc64le                                                                                                         4/4  

Installed:
 postgresql12-contrib.ppc64le 0:12.7-1PGDG.rhel7                                     postgresql12-server.ppc64le 0:12.7-1PGDG.rhel7                                     

Dependency Installed:
 postgresql12.ppc64le 0:12.7-1PGDG.rhel7                                          postgresql12-libs.ppc64le 0:12.7-1PGDG.rhel7                                          

Complete!
[root@hdpmaster yum.repos.d]# systemctl status postgresql-12.service
● postgresql-12.service - PostgreSQL 12 database server
  Loaded: loaded (/usr/lib/systemd/system/postgresql-12.service; disabled; vendor preset: disabled)
  Active: inactive (dead)
    Docs: https://www.postgresql.org/docs/12/static/
[root@hdpmaster yum.repos.d]# systemctl start postgresql-12.service  
Job for postgresql-12.service failed because the control process exited with error code. See "systemctl status postgresql-12.service" and "journalctl -xe" for details.
[root@hdpmaster yum.repos.d]# systemctl enable --now postgresql-12
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-12.service to /usr/lib/systemd/system/postgresql-12.service.
Job for postgresql-12.service failed because the control process exited with error code. See "systemctl status postgresql-12.service" and "journalctl -xe" for details.
[root@hdpmaster yum.repos.d]# systemctl status postgresql-12.service
postgresql-12.service - PostgreSQL 12 database server
  Loaded: loaded (/usr/lib/systemd/system/postgresql-12.service; enabled; vendor preset: disabled)
  Active: failed (Result: exit-code) since Sel 2021-05-25 16:38:42 WIB; 11s ago
    Docs: https://www.postgresql.org/docs/12/static/
 Process: 16727 ExecStartPre=/usr/pgsql-12/bin/postgresql-12-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)

Mei 25 16:38:42 hdpmaster systemd[1]: Starting PostgreSQL 12 database server...
Mei 25 16:38:42 hdpmaster systemd[1]: postgresql-12.service: control process exited, code=exited status=1
Mei 25 16:38:42 hdpmaster systemd[1]: Failed to start PostgreSQL 12 database server.
Mei 25 16:38:42 hdpmaster systemd[1]: Unit postgresql-12.service entered failed state.
Mei 25 16:38:42 hdpmaster systemd[1]: postgresql-12.service failed.
[root@hdpmaster yum.repos.d]# reboot
Connection to 172.16.9.30 closed by remote host.
Connection to 172.16.9.30 closed.
dbsa@dbsa-X406UA:~$

Tidak ada komentar:

Posting Komentar