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