PostgreSQL

Install

Install postgresql and postgis for coordinates data

sudo apt install postgresql postgis -y

Login

sudo -u postgres psql

Change password to default account

ALTER USER postgres WITH PASSWORD 'new password';

Restrict remote access to localhost only

Open the config file

nano /etc/postgresql/15/main/postgresql.conf

uncomment this line

listen_addresses = 'localhost'

if you need remote access

listen_addresses = '0.0.0.0'

and Edit /etc/postgresql/15/main/pg_hba.conf and add a line like:

host    all             all             192.168.1.0/24          scram-sha-256