LatestVirtualization

Install Postgresql

sudo apt install -y postgresql
sudo -u postgres psql
ALTER USER postgres PASSWORD <mypassword>;
sudo nano /etc/postgresql/16/main/postgresql.conf

listen_addresses = '*'  # allow all IP's
nano /etc/postgresql/16/main/pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# IPv4
host    all             all             <xxx.xxx.xxx.0/24>      scram-sha-256
# allow all IP's from xxx.xxx.xxx.* 
sudo systemctl restart postgersql

Leave a Reply