EnterpriseDB Postgres Advanced Server 12 Beta support on 64 bit Linux ( Red Hat Enterprise Linux (x86_64) 7.x & CentOS (x86_64) 7.x ). You can use RPM packages to install Advanced Server and supporting components on a Linux host. Before installing Advanced Server make sure prerequisites insalled on machine, if its not installed you can install through following command by using system root user privileges.
# yum install epel-release
Before installing the Advanced Server version 12 beta or a supporting component, you needs to request access to the EnterpriseDB repository and after this you can use your choice of editor to create the repository file edb_beta.repo under /etc/yum.repos.d/ . Copy the following contents in edb_beta.repo file and save changes.
[edb-testing]
name=EnterpriseDB Advanced Server 12 $releasever - $basearch
baseurl=https://username:password@yum.enterprisedb.com/edb-testing/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY
Provide username:password for EnterpriseDB repository. You can get further details from https://stagecms.enterprisedb.com/beta-programs/edb-postgres-advanced-server-v120-beta.
For EnterpriseDB Postgres Advanced Server 12 beta installation you further needs to download the repository key. You needs to use following command for key:
# curl -o /etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY https://username:password@yum.enterprisedb.com/ENTERPRISEDB-GPG-KEY
In the above command you need to replace username:password with the registered EnterpriseDB user and password. Then, use the following command to install the key:
# rpm --import /etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY
Now all the environment ready and you can futher proceed for edb-as12-server installation through following commands.
# yum clean all
# yum install edb-as12-server
=============================================================================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================================================================
Installing:
edb-as12-server x86_64 12.0.1-1.rhel7 edb-testing 5.7 k
Installing for dependencies:
boost-atomic x86_64 1.53.0-27.el7 base 35 k
boost-chrono x86_64 1.53.0-27.el7 base 44 k
boost-filesystem x86_64 1.53.0-27.el7 base 68 k
boost-regex x86_64 1.53.0-27.el7 base 300 k
edb-as12-libicu x86_64 53.1-1.rhel7 edb-testing 7.4 M
edb-as12-pgagent x86_64 4.0.0-1.rhel7 edb-testing 174 k
edb-as12-server-client x86_64 12.0.1-1.rhel7 edb-testing 1.4 M
edb-as12-server-cloneschema x86_64 1.10-1.rhel7 edb-testing 23 k
edb-as12-server-contrib x86_64 12.0.1-1.rhel7 edb-testing 660 k
edb-as12-server-core x86_64 12.0.1-1.rhel7 edb-testing 5.7 M
edb-as12-server-devel x86_64 12.0.1-1.rhel7 edb-testing 2.5 M
edb-as12-server-docs x86_64 12.0.1-1.rhel7 edb-testing 14 k
edb-as12-server-indexadvisor x86_64 12.0.1-1.rhel7 edb-testing 57 k
edb-as12-server-libs x86_64 12.0.1-1.rhel7 edb-testing 611 k
edb-as12-server-llvmjit x86_64 12.0.1-1.rhel7 edb-testing 11 M
edb-as12-server-parallel-clone x86_64 1.5-1.rhel7 edb-testing 70 k
edb-as12-server-pldebugger x86_64 1.1-1.rhel7 edb-testing 90 k
edb-as12-server-plperl x86_64 12.0.1-1.rhel7 edb-testing 57 k
edb-as12-server-plpython x86_64 12.0.1-1.rhel7 edb-testing 78 k
edb-as12-server-pltcl x86_64 12.0.1-1.rhel7 edb-testing 38 k
edb-as12-server-sqlprofiler x86_64 4.0-1.rhel7 edb-testing 88 k
edb-as12-server-sqlprotect x86_64 12.0.1-1.rhel7 edb-testing 102 k
edb-as12-server-sslutils x86_64 1.2-1.rhel7 edb-testing 43 k
llvm5.0 x86_64 5.0.1-7.el7 epel 2.6 M
llvm5.0-libs x86_64 5.0.1-7.el7 epel 13 M
Transaction Summary
...
After the edb-as12-server beta packages instalaltion now you are ready to create a database cluster and start the service. To invoke initdb on a RHEL or CentOS 7.x system you need to execute edb-as-12-setup file, assume the identity of the operating system superuser:
$ su - root
# /usr/edb/as12/bin/edb-as-12-setup initdb
Initializing database ... OK
Cluster initialization on default location ( /var/lib/edb/as12) perform successfully, now you can start, stop and restart cluster through systemctl command.
systemctl { start | stop | restart } edb-as-12
# systemctl start edb-as-12
# systemctl status edb-as-12
edb-as-12.service - EDB Postgres Advanced Server 12
Loaded: loaded (/usr/lib/systemd/system/edb-as-12.service; disabled; vendor preset: disabled)
Active: active (running) since Fri 2019-08-23 11:33:02 IST; 21s ago
Process: 12777 ExecStartPre=/usr/edb/as12/bin/edb-as-12-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
....
Your EntpriseDB Postgres Advanced Server 12 beta ready for use. You can switch to enterprisedb user and connect psql with running database.
# su - enterprisedb
-bash-4.2$ psql edb
psql (12.0.1, server 12.0.1)
Type "help" for help.
edb=#
.png "EDB Team Member"){kind=icon}