dokuwiki

This is an old revision of the document!

---

create user, and then database for that user.

  sudo -u postgres psql
  postgres=# create database mydb;
  postgres=# create user myuser with encrypted password 'mypass';
  postgres=# grant all privileges on database mydb to myuser;

to enable logins from external systems:

find / -name "postgresql.conf"

find in there listen_addresses = 'localhost', change to listen_addresses = '*'

pga_hba.conf is probably right next to it. add these:

host    all             all              0.0.0.0/0                       md5
host    all             all              ::/0                            md5