PostgreSQL: Remote Connection

—

Create user:

CREATE USER <username> WITH PASSWORD <password>;

Create a database:

CREATE DATABASE <database-name>;

Grant user to database:

GRANT ALL PRIVILEGES ON DATABASE <database-name> TO <username>;

Grant user to schema:

GRANT ALL ON SCHEMA public TO <username>;

Configure the server:

listen_addresses = '*'

Configure server access:

host    all             test            10.40.11.1/24           md5

Restart posgresql:

systemctl restart postgresql

Comments