postgresql & linux: pg_hba.conf example

Trabla: postgresql & linux: pg_hba.conf example

Solving:

1. Open for edit:
sudo pico /etc/postgresql/9.3/main/pg_hba.conf

2. Add your web-server + save

host DBNAME DBUSER WEBSERVERIP/32 trust

e.g.

host moodle postgres 127.0.0.1/32 trust


3. Allow listening of all IP addresses - open file postgresql.conf
listen_addresses = '*'

4. Restart postgresl

sudo service postgresql restart

No comments:

Post a Comment