DEV Community

Cover image for Installing EDB Postgres Advanced Server on Ubuntu 22.04
Ahmed Mohamed
Ahmed Mohamed

Posted on

Installing EDB Postgres Advanced Server on Ubuntu 22.04

Introduction

EDB EnterpriseDB is a robust and feature-rich open-source database management system (DBMS) built upon PostgreSQL. If you're considering leveraging EDB EnterpriseDB for your Linux environment, this step-by-step guide will walk you through the installation process.

Installation steps

update your package manager

sudo apt update
Enter fullscreen mode Exit fullscreen mode

. Set up the EDB repository
Setting up the repository is a one-time task. If you have already set up your repository, you don't need to perform this step.

To determine if your repository exists, enter this command:

apt-cache search enterprisedb
Enter fullscreen mode Exit fullscreen mode

If no output is generated, the repository isn't installed.

To set up the EDB repository:

  • Go to EDB repositories.
  • Select the button that provides access to the EDB repo.
  • Select the platform and software that you want to download.

Install the package

sudo apt-get -y install edb-as<xx>-server
Enter fullscreen mode Exit fullscreen mode

Where <xx> is the version of the EDB Postgres Advanced server you are installing. For example, if you are installing version 15, the package name would be edb-as15-server.

To install an individual component:

sudo apt-get -y install <package_name>
Enter fullscreen mode Exit fullscreen mode

Initial configuration

This section steps you through getting started with your cluster including logging in, ensuring the installation was successful, connecting to your cluster, and creating the user password.

To work in your cluster, login as the enterprisedb user. Connect to the database server using the psql command line client (although you can use a client of your choice with the appropriate connection string).

sudo su - enterprisedb

psql edb
Enter fullscreen mode Exit fullscreen mode

The server runs with the peer or ident permission by default. You can change the authentication method by modifying the pg_hba.conf file.

Before changing the authentication method, assign a password to the database superuser, enterprisedb. For more information on changing the authentication, see modifying the pg_hba.conf file.

ALTER ROLE enterprisedb IDENTIFIED BY password;
Enter fullscreen mode Exit fullscreen mode

Ref:
EDB DOCs

Top comments (0)