Quick start for CentOS or RHEL 7 v15
EDB Postgres Advanced Server adds extended functionality to the open-source PostgreSQL database that supports database administration, enhanced SQL capabilities, database and application security, performance monitoring and analysis, and application development utilities. EDB Postgres Advanced Server also supports database compatibility features for Oracle users; for detailed information about compatibility features, see the EDB Postgres Advanced Server documentation.
This guide walks you through using yum
to install EDB Postgres Advanced Server on a RHEL or CentOS 7 system and deploying a database cluster. The database created by this tutorial is well-suited for experimentation and testing. There are additional security and resource considerations when configuring a production installation that are not covered by this document.
This guide assumes that you are familiar with simple operating system and system administration procedures, and have administrative privileges on the host on which EDB Postgres Advanced Server is installed.
Components of an EDB Postgres Advanced Server deployment
Among the components that make up an EDB Postgres Advanced Server deployment are:
The Database server - The database server (the postmaster
) is the service that provides the key functionality that allows you to store and manage data. EDB Postgres Advanced Server is built on the PostgreSQL open-source database project; it includes all of the documented features of community PostgreSQL and more.
The database cluster - A cluster is a set of on-disk structures that comprise a collection of databases. A cluster is serviced by a single-instance of the database server. A database cluster is stored in the data
directory. Don't store the data
directory of a production database on an NFS file system.
Configuration files - You can use the parameters listed in Postgres configuration files to manage deployment preferences, security preferences, connection behaviors, and logging preferences.
Supporting tools, utilities, and clients - EDB makes available a full suite of tools and utilities that can help you monitor and manage your EDB Postgres Advanced Server deployment. For more information, visit the EDB website.
Supporting functions, rocedures, data types, index types, operators, utilities, and aggregates - EDB Postgres Advanced Server includes a number of features that help you manage your data.
Prerequisites
Before installing EDB Postgres Advanced Server, use yum
to install prerequisite packages:
If you are installing Migration Toolkit or EDB*Plus, you must first install Java:
Installing and configuring EDB Postgres Advanced Server
Step 1: You must register with EDB to receive credentials for the EDB repository. For information about requesting credentials, visit the https://www.enterprisedb.com/user/login.
Step 2: Assume superuser privileges to install the EDB repository configuration package:
Step 3: The repository configuration file is named edb.repo
. The file resides in /etc/yum.repos.d
. Ensure the username
and password
placeholders in the baseurl specification matches with the name and password of a registered EDB user.
Step 4: Update the cache and install EDB Postgres Advanced Server:
Step 5: Use sudo to assume the identity of the enterprisedb
database superuser and create an EDB Postgres Advanced Server cluster named acctg
on listener port 5444
:
Starting the cluster
As the enterprisedb
user, start the cluster:
You can check the status of the cluster with the command:
Using the psql command line client
After installing the server and initializing a cluster, you can connect to the database with your choice of client. For convenience, the server is deployed with the pgAdmin 4 graphical client and the psql command line client.
As the enterprisedb
user, open a psql session:
Then, assign a password to the enterprisedb
user:
Create a database (named hr
):
Connect to the new database and create a table (named dept
):
Add data to the table:
You can use simple SQL commands to query the database and retrieve information about the data you have added to the table:
Or, create database users:
For detailed product usage information, see the EDB Postgres Advanced Server documentation available at the EDB website.