Breadcrumbs

Setting up the EDB Postgres Advanced Server

Follow the steps below for setting up the EDB Postgres Advanced Server on a Linux server. The steps are based on the EDB Postgres Advanced Server EDB Docs - EDB Postgres Advanced Server v17 - Installing EDB Postgres Advanced Server on AlmaLinux 9 or Rocky Linux 9 x86_64. 

  1. Setting up the repository is a one-time task. Check if the repository already exists on the Linux machine.
    Use the commands below to confirm the repository exists. If no output is generated, the repository isn't installed.
    $ sudo dnf repolist | grep enterprisedb 

33848923-4ca4-4370-ae82-c110b951da16.png

Linux Terminal: command related to EDB repo check

  1. Go to the EDB repository https://www.enterprisedb.com/repos-downloads.
    Accessing this repository requires an EDB user account, which can be created from the following URL: Account management | EDB.
    Select Access EDB Repos 2.0 as highlighted in the figure below.

image-20250711-145122.png

EDB official website: Repo access

  1. Select the required platform and software to download.

    1. Select the platform from the Select Platform drop-down list.

      image-20250711-145223.png
      EDB official website: Platform selection for EDB repo

    2. Select Rocky Linux 9 from the drop-down list, as it is used for testing.

      image-20250711-145319.png
      EDB official website: Rocky Linux 9 selection

    3. Select Software EDB Postgres Advanced Server version 17, as the figure below highlights.

      image-20250711-145450.png
      EDB official website: Select the software ‘EDB Postgres Advanced Server’

  1. Set up the repository using the link from the EDB repository

    1. The repository URL is specified in the figure below.

      image-20250711-145633.png
      EDB official website: EDB Postgres Advanced Server repo urls

    2. Execute the command below on a Linux machine.
      $ curl -1sSLf 'https://downloads.enterprisedb.com/XjIen8pK8khp21EYGKpmi7Z52BmxpXi9/enterprise/setup.rpm.sh' | sudo -E bash

      4b202a0a-f376-4761-8e85-f6fc9c8e1d74.png
      Linux Terminal: EDB repository setup

  2. Install the software packages.
    The command for installing the software package is sudo dnf -y install edb-as<xx>-server, where <xx> is the version of EDB Postgres Advanced Server. For version 17, use the command below.
    $ sudo dnf -y install edb-as17-server

image-20250711-145825.png

Linux Terminal: Install the edb-as17-server software package

  1. Install the EPEL repository.
    Use this command for EPEL installation.
    $ sudo dnf -y install epel-release

image-20250711-145907.png

Linux Terminal: installing EPEL repository

  1. Enable additional repositories to resolve dependencies.
    Use this command to enable additional repositories.
    $ sudo dnf config-manager --set-enabled crb

image-20250711-150304.png

Linux Terminal: enabling the additional repositories to resolve dependencies

  1. Disable the built-in PostgreSQL module.
    Use this command to disable any existing PostgreSQL module.
    $ sudo dnf -qy module disable postgresql 

  1. Install the PostgreSQL packages
    Use this command to install PostgreSQL.
    $ sudo dnf -y install postgresql17-server postgresql17-contrib

image-20250711-150357.png


Linux Terminal: installing the PostgreSQL package

10. Installing the server package creates an operating system user named enterprisedb. The user has no default password, so a password needs to be set using the passwd command.
$ sudo passwd enterprisedb 

11. Make sure the user enterprisedb has sudo privileges.
$ sudo usermod -aG wheel enterprisedb