DEV Community

steila
steila

Posted on

Step-by-step guide on installing Postgres Enterprise Server Via a Linux distro (Ubuntu).

Introduction
Postgres Enterprise Manager (PEM) is a monitoring tool used for managing multiple instances of Postgres databases. It offers the flexibility of installation on Windows either through a Linux distribution like Ubuntu or directly as an executor. In this tutorial, I will work you through installing it via a Linux distro (Ubuntu 22.04) on Windows.

WSL Installation.
On your Windows machine, do the following;

  1. Open settings > apps> optional features > more windows features > enable WSL.

  2. This would prompt you to reboot your system.

  3. Visit the Microsoft store, install Ubuntu 22.04 and follow the prompts.

EDB Advanced Server Installation Guide

  1. Visit the EDB repositories.

  2. Create an account.

  3. Click on Repo access.

  4. Select access EDB Repos 2.0.

  5. Select platform Ubuntu 22.04 LTS (Jammy) x86_64, and software EDB Postgres Advanced Server, so its installation instructions can be displayed.

  6. Configure the repository by running this command on your Ubuntu.

    curl -1sLf 'https://downloads.enterprisedb.com/p7lPKTUSJ8jNZlqUAlrQuxMKfk6X2Ya6/enterprise/setup.deb.sh' | sudo -E bash

  7. Install the EDB Advanced server by running this command.

    sudo apt-get -y install edb-as15-server

  8. You will see this output below

    image showing a successful installation

  9. To confirm your installation, you can start the server by running this command below or any command displayed after the installation process.

    /usr/lib/edb-as/15/bin/pg_ctl -D /var/lib/edb-as/15/main -l logfile start

PEM Server Installation Guide.

  1. Visit the EDB repositories again.

  2. Select platform as Ubuntu 22.04 LTS (Jammy) x86_64, and software EDB Postgres Enterprise Manager, so its installation instructions can be displayed.

  3. Configure the repository by running this command on your Ubuntu.

    curl -1sLf 'https://downloads.enterprisedb.com/p7lPKTUSJ8jNZlqUAlrQuxMKfk6X2Ya6/enterprise/setup.deb.sh' | sudo -E bash

  4. Install the PEM server by running this command.

    sudo apt-get -y install edb-pem

  5. Configure the PEM server by running this code, it will ask you for series of information, be sure to fill them.

    /usr/edb/pem/bin/configure-pem-server.sh

  6. After a successful configuration, this will be outputted to the screen.

    https://<ip_address_of_PEM_server>:8443/pem

  7. Visit the URL above in your browser.

References.
https://www.enterprisedb.com/docs/pem/latest/installing/linux_x86_64/pem_ubuntu_22/
https://www.postgresql.org/download/
https://www.postgresql.org/download/linux/ubuntu/
https://www.enterprisedb.com/docs/epas/latest/installing/
https://www.enterprisedb.com/docs/pem/latest/managing_database_server/#modifying-the-pg_hbaconf-file

Top comments (0)