.::: Install EnterpriseDB 15 (EDB 15) in Centos 7 :::.

 
1. get repo access from web login using new account only one month
https://www.enterprisedb.com/accounts/login

https://www.enterprisedb.com/repos


2. curl & install setup.rpm.sh
[root@teguhth data]# curl -1sLf 'https://downloads.enterprisedb.com/f9xxxxxxx/enterprise/setup.rpm.sh' | sudo -E bash
Executing the  setup script for the 'enterprisedb/enterprise' repository ...

   OK: Checking for required executable 'curl' ...
   OK: Checking for required executable 'rpm' ...
   OK: Detecting your OS distribution and release using system methods ...
 ^^^^: ... Detected/provided for your OS/distribution, version and architecture:
 >>>>:
 >>>>: ... distro=centos  version=7  codename=Core  arch=x86_64
 >>>>:

   OK: Importing 'enterprisedb/enterprise' repository GPG keys into rpm ...
   OK: Checking for available package manager (DNF/Microdnf/YUM/Zypper) ...
 ^^^^: ... Detected package manager as 'yum'
 NOPE: Checking for yum dependency 'yum-utils' ...
   OK: Attempting to install 'yum-utils' ...
   OK: Checking if upstream install config is OK ...
   OK: Fetching 'enterprisedb/enterprise' repository configuration ...
   OK: Installing 'enterprisedb/enterprise' repository via yum ...
  RUN: Updating the yum cache to fetch the new repository metadata ...Importing GPG key 0x9xxxx:
 Userid     : "Cloudsmith Package (enterprisedb/enterprise) <support@cloudsmith.io>"
 Fingerprint: 31a4 cf09 xxxxx
 From       : https://downloads.enterprisedb.com/f9xxxxx/enterprise/gpg.E7xxxxx.key
Importing GPG key 0x9F1EF813:
 Userid     : "Cloudsmith Package (enterprisedb/enterprise) <support@cloudsmith.io>"
 Fingerprint: 31a4 cf09 xxxxx
 From       : https://downloads.enterprisedb.com/f9xxxx/enterprise/gpg.E71EB0829F1EF813.key
Importing GPG key 0xxxx:
 Userid     : "Cloudsmith Package (enterprisedb/enterprise) <support@cloudsmith.io>"
 Fingerprint: 31a4 xxxx
 From       : https://downloads.enterprisedb.com/f9xxxx/enterprise/gpg.Exxxx.key
   OK: Updating the yum cache to fetch the new repository metadata ...
   OK: The repository has been installed successfully - You're ready to rock!

[root@teguhth data]#

3. install pygpgme
[root@teguhth data]# yum install yum-utils pygpgme -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: vpsmurah.jagoanhosting.com
 * extras: vpsmurah.jagoanhosting.com
 * updates: vpsmurah.jagoanhosting.com
Package yum-utils-1.1.31-54.el7_8.noarch already installed and latest version
Package pygpgme-0.3-9.el7.x86_64 already installed and latest version
Nothing to do
[root@teguhth data]#
l7.x86_64 already installed and latest version
Nothing to do

4. Install gpg key
[root@teguhth data]#
[root@teguhth data]# rpm --import 'https://downloads.enterprisedb.com/f9Qxxxx/enterprise/gpg.E7xxx.key'

5. create repo edb
[root@teguhth data]# curl -1sLf 'https://downloads.enterprisedb.com/f9Qxxxx/enterprise/config.rpm.txt?distro=el&codename=7' > /tmp/enterprisedb-enterprise.repo
[root@teguhth data]#

6. add configmanager
[root@teguhth data]# yum-config-manager --add-repo '/tmp/enterprisedb-enterprise.repo'
Loaded plugins: fastestmirror
adding repo from: /tmp/enterprisedb-enterprise.repo
grabbing file /tmp/enterprisedb-enterprise.repo to /etc/yum.repos.d/enterprisedb-enterprise.repo
repo saved to /etc/yum.repos.d/enterprisedb-enterprise.repo
[root@teguhth data]#

7. disable repochache
[root@teguhth data]#
[root@teguhth data]# yum -q makecache -y --disablerepo='*' --enablerepo='enterprisedb-enterprise'
[root@teguhth data]#

8. Install Enterprise 15
[root@teguhth data]# yum -y install edb-as15-server

9. Setup database
[root@teguhth data]# PGSETUP_INITDB_OPTIONS="-E UTF-8" /usr/edb/as15/bin/edb-as-15-setup initdb
Initializing database ... OK

[root@teguhth data]#

10. Start & enable edb service
[root@teguhth data]# systemctl start edb-as-15
[root@teguhth data]# systemctl enable edb-as-15
Created symlink from /etc/systemd/system/multi-user.target.wants/edb-as-15.service to /usr/lib/systemd/system/edb-as-15.service.
[root@teguhth data]#


11. login
[root@teguhth data]# su - enterprisedb
Last login: Mon Jul 17 13:17:35 WIB 2023 on pts/0
-bash-4.2$ psql
-bash-4.2$ psql edb
psql (15.3.0, server 15.3.0)
Type "help" for help.

edb=#

12. create password for enterprise
edb=#
edb=# ALTER ROLE enterprisedb IDENTIFIED BY password;
ALTER ROLE
edb=#

 

13. create sample database

http://teguhth.blogspot.com/2019/09/study-kasus-praktis-belajar-query.html