Installing and running EDB Postgres Advanced Server cluster on RHEL 6 or RHEL 7

January 20, 2023

Objective

Quickly (less than five minutes) install and run a default EPAS 11 cluster on RHEL 6 or RHEL 7

 

Prerequisites

Running instance of RHEL/CentOS 6/7 with root access

 

Components

There are three primary components to EPAS:

EPAS 11 Installation (/var/lib/edb/as11/)

EPAS 11 Cluster Directories (user configurable, but defaults to /var/lib/edb/as11/data)

pg_hba.conf - Postgres Host Based Access file specifices who can connect to the cluster
postgresql.conf - Postgres main configuration file with all other configuration settings for the cluster

# # Congratulations! You have successfully installed, configured, and connected to your first EPAS 11 cluster.

##Here is a quick, complete example for installing EDB Postgres v10 on RHEL/CentOS 6/7:

#
# Install the new EDB Repo
#
yum install -y http://yum.enterprisedb.com/edbrepos/edb-repo-latest.noarch.rpm
yum install -y epel-release
#
# Configure the edb.repo username/password
#

#
# Enable EPAS 10, dependencies, and tools repositories
#
# Configure the edb.repo username/password
#

#
# Enable EPAS 10, dependencies, and tools repositories
#
export YUM_USER= #####Please provide your username for the edb yum repo
export YUM_PASSWORD=  ###Please provide your password for the edb yum repo

# Configure the edb.repo username/password
#
#
# Enable EPAS 10, dependencies, and tools repositories
#

sed -i "s/<username>:<password>/$YUM_USER:$YUM_PASSWORD/g" /etc/yum.repos.d/edb.repo
sed -i "\/edbas11/,/gpgcheck/ s/enabled=0/enabled=1/" /etc/yum.repos.d/edb.repo
sed -i "\/enterprisedb-dependencies/,/gpgcheck/ s/enabled=0/enabled=1/" /etc/yum.repos.d/edb.repo
sed -i "\/enterprisedb-tools/,/gpgcheck/ s/enabled=0/enabled=1/" /etc/yum.repos.d/edb.repo
#

# Install EPAS 11
#
#yum install -y edb-as11-server-core ##if you want to install just the core-database
yum install -y edb-as11-server

if [ `cat /etc/redhat-release | grep "release 7" | wc -l` = 1 ]
then
/usr/edb/as11/bin/edb-as-11-setup initdb
su - enterprisedb -c "sed -i \"s/ident/md5/g\" /var/lib/edb/as11/data/pg_hba.conf" \
&& echo "host all all 0.0.0.0/0 md5" >>/var/lib/edb/as11/data/pg_hba.conf
systemctl start edb-as-11
su - enterprisedb -c "/usr/edb/as11/bin/psql -d edb -c 'alter user enterprisedb identified by enterprisedb'"
elif [ `cat /etc/redhat-release | grep "release 6" | wc -l` = 1 ]
then
service edb-as-11 initdb
su - enterprisedb -c "sed -i \"s/ident/md5/g\" /var/lib/edb/as11/data/pg_hba.conf" \
&& echo "host all all 0.0.0.0/0 md5" >>/var/lib/edb/as11/data/pg_hba.conf
su - enterprisedb -c "psql -d edb -c 'alter user enterprisedb identified by enterprisedb'"
service edb-as-11 start
fi


su - enterprisedb
psql -d edb
select version();
select * from dual;
exit
exit

 

Summary

This guide is intended to get you up and started with a default installation of EPAS 11 as quickly as possible.  This is just the beginning though.  Please stay tuned for more tutorials and demos of specific features available in EPAS 11

Share this

Relevant Blogs

Why you should use Docker Compose

h2 { text-align: left !important; } .summary{ background:#f3f7f9; padding:20px; } SUMMARY: This article explains the benefits of using Docker Compose for creating multiple container applications. It reviews the steps for...
January 24, 2023

More Blogs

Quickstart guide on using pgPool

Steps (as root user)   #!/bin/bash   # Setup YUM repository for installing EPAS as the PEM # repository rpm -Uvh   # Set YUM username/password in edb.repo export YUM_USER=
January 24, 2023

Using auth_method=hba in PgBouncer

Introduction PgBouncer is a great tool for improving database performance with connection pooling.  I've been using it for many years, since it first became available in 2007.  Since then, several...
January 23, 2023