Postgres Installation Steps (This example uses Ubuntu, the Linux commands will be slightly different on other Linux flavours)

Here is an article that explains how to install PostgreSQL 16 on RHEL-Based Linux

https://www.tecmint.com/install-postgresql-on-centos-rhel-fedora/

1. Set up PostgreSQL repositories by installing necessary tools, creating directories and downloading the PostgreSQL signing key
   
1. Install the curl tools and ensures that the system has the necessary certificates to verify secure connections:
   sudo apt install curl ca-certificates
2. Create a directory /usr/share/postgresql-common/pgdg , which will be used to store the signing key:
   sudo install -d /usr/share/postgresql-common/pgdg
3. Download the PostgreSQL Apt repository signing key: 
   sudo apt install -y postgresql-common
   sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
2. Apply the latest Linux updates:  sudo apt-get update
   
3. Install PostgreSQL 16 Repository:  sudo apt -y install postgresql
   
4. Allow other computers to connect to Postgres (replace <version> with the installed version of PostgreSQL:  
   sudo vi /etc/postgresql/<version>/main/postgresql.conf
   
5. Change listen_address from localhost to *, and remove the '#' in front of listen_addresses
   listen_addresses = ‘*’
6. Ensure PostgreSQL is running by running: sudo systemctl status postgresql
   
1. If it's not running, start PostgreSQL: sudo systemctl start postgresql
7. Set the password for the postgres user:  sudo -u postgres psql template1
   
8. Run this SQL:  alter user postgres with encrypted password ‘your_password’;
   
9. Type: exit
   
10. Change the authentication for the postgres user allowed for the template1 database to use md5 authentication:
    sudo vi /etc/postgresql/<version>/main/pg_hba.conf
11. Add this line (changing <local network IP> to your private IP):
    hostssl  template1           all               <local network IP>           md5
12. Restart Postgres:  sudo systemctl restart postgresql.service
    
13. Create a Postgres user for the Digital Hive content store
    
1. Switch user to postgres
   sudo su postgres
2. Run postgresql: psql 
   
14. At the postgres=# prompt, run this SQL (replacing your_password the password you want)
    
1. CREATE ROLE dhadmin WITH LOGIN CREATEROLE INHERIT CONNECTION LIMIT -1 VALID UNTIL '3024-08-10T05:30:17-05:00' PASSWORD 'your_password';
   
2. CREATE DATABASE digitalhive WITH OWNER = dhadmin TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' CONNECTION LIMIT = -1;
   
15. Give the dhadmin user access to the public schema
16. grant all on schema public to dhadmin;
    
17. Exit psql
    exit

You now have a Postgres Digital Hive database that can be used for the Digital Hive content store