Quick Start Guide for Linux on CentOS or RHEL 7 v13
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. Advanced Server also supports database compatibility features for Oracle users; for detailed information about compatibility features, see the Advanced Server documentation.
This guide will walk 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 Advanced Server will be installed.
Please note that if you are using the pdf version of this document, using cut/paste to copy a command may result in extra spaces or carriage returns in the pasted command. If a command fails, check the command carefully for extra characters.
Components of an EDB Postgres Advanced Server Deployment
Among the components that make up an 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. 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; please note that the
data directory of a production database should not be stored 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 Advanced Server deployment. For more information, visit the EDB website.
Supporting Functions, Procedures, Data Types, Index Types, Operators, Utilities, and Aggregates - Advanced Server includes a number of features that help you manage your data.
Before installing 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 Advanced Server
Step 1: You must register with EDB to receive credentials for the EDB repository. If you have not previously registered with EDB, visit the EDB site for information about requesting credentials.
Step 2: Assume superuser privileges to install the EDB repository configuration package:
Step 3: With your choice of editor, edit the
/etc/yum.repos.d/edb.repo file, replacing the
password placeholders in the baseurl specification with the name and password of a registered EDB user and ensure that the
enabled properties are set to
Step 4: Update the cache and install Advanced Server:
Step 5: Use sudo to assume the identity of the
enterprisedb database superuser and create an Advanced Server cluster named
acctg on listener port
Starting the Cluster
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.
enterprisedb user, open a psql session:
Then, assign a password to the
Create a database (named
Connect to the new database and create a table (named
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 Advanced Server documentation, available at the EDB website.