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;
Open settings > apps> optional features > more windows features > enable WSL.
This would prompt you to reboot your system.
Visit the Microsoft store, install Ubuntu 22.04 and follow the prompts.
EDB Advanced Server Installation Guide
Visit the EDB repositories.
Create an account.
Click on Repo access.
Select access EDB Repos 2.0.
Select platform
Ubuntu 22.04 LTS (Jammy) x86_64
, and software EDB Postgres Advanced Server, so its installation instructions can be displayed.-
Configure the repository by running this command on your Ubuntu.
curl -1sLf 'https://downloads.enterprisedb.com/p7lPKTUSJ8jNZlqUAlrQuxMKfk6X2Ya6/enterprise/setup.deb.sh' | sudo -E bash
-
Install the EDB Advanced server by running this command.
sudo apt-get -y install edb-as15-server
-
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.
Visit the EDB repositories again.
Select platform as
Ubuntu 22.04 LTS (Jammy) x86_64
, and software EDB Postgres Enterprise Manager, so its installation instructions can be displayed.-
Configure the repository by running this command on your Ubuntu.
curl -1sLf 'https://downloads.enterprisedb.com/p7lPKTUSJ8jNZlqUAlrQuxMKfk6X2Ya6/enterprise/setup.deb.sh' | sudo -E bash
-
Install the PEM server by running this command.
sudo apt-get -y install edb-pem
-
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
-
After a successful configuration, this will be outputted to the screen.
https://<ip_address_of_PEM_server>:8443/pem
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)