Fresh Install Enterprise Manager 24.12 on Linux

Product 

  • exacqVision Enteprise Manager ver 24.12

Requirements

Ubuntu 20.04 or higher

Manually installing PostgreSQL 17

Remove any installed EM server if existed

sudo apt-get --purge remove esm

Installing PostgreSQL

Update Ubuntu repository list

sudo apt-get update
sudo apt-get upgrade

Install PostgreSQL 17

sudo apt-get install postgresql-17
  1. Change the default PostgreSQL connection type to from peer to trust, then save:
sudo cp /usr/share/postgresql/17/pg_hba.conf.sample /usr/share/postgresql/17/pg_hba.conf

sudo nano /usr/share/postgresql/17/pg_hba.conf

Note: Ensure that the line is `local all postgres trust`.

Sometimes you would need to allow access via TCP/IP in the pg_hba.conf file

# Allow access from localhost via TCP/IP

host    all             all             127.0.0.1/32            md5

host    all             all             ::1/128                 md5
  1. Restart the PostgreSQL service:
    Note: The service name may differ on your system.
sudo service restart postgresql

Creating a database on the new PostgrSQL

To check if PostgreSQL is working and listening on port 5432

sudo ss -plnt | grep 5432

Connect to PostgreSQL

sudo -u postgres psql

Create a database on the new PostgreSQL installation, enter:

CREATE DATABASE "EnterpriseManager";

Then, in the psql terminal:

ALTER USER postgres WITH PASSWORD 'postgres';

Grant All Privileges on the database

GRANT ALL PRIVILEGES ON DATABASE EnterpriseManager TO postgres;

Installing Enterprise Manager 24.12

Download Enterprise Manager 

wget {ESM file download URL}

Install ESM server

sudo dpkg -i {ESM downloaded deb file}

For upgrading PostgreSQL, Please follow the instructions on KB21672