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 = '*'

Allow user to connect

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

host    all             all             10.0.0.0/8            trust

Replace IP address as needed!