PostgresSQL create db,user networkaccess

sudo -u postgres psql
CREATE DATABASE mydb;
CREATE USER myuser WITH PASSWORD 'StrongPassword123!';
GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser;
ALTER DATABASE mydb OWNER TO myuser;
\q

sudo vi /etc/postgresql/*/main/postgresql.conf
listen_addresses = '*'
or
listen_addresses = '192.168.1.100'

sudo vi /etc/postgresql/*/main/pg_hba.conf
host mydb myuser 203.0.113.25/32 scram-sha-256

sudo systemctl restart postgresql
sudo systemctl status postgresql

sudo ufw allow 5432/tcp
sudo ufw status

psql -h YOUR_SERVER_IP -U myuser -d mydb