PostgreSQL Server Configuration

Open SQL shell

sudo -u postgres psql

Create database and user

create database dbname;
create user user with encrypted password 'password';
grant all privileges on database dbname to user;

Listen on all interfaces

In /etc/postgresql/version/main/postgresql.conf:

listen_addresses = '*'