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
- 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
- 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