Changes between Version 73 and Version 74 of InstallationGuidelines/PostgreSQL

Timestamp:

03/02/16 11:28:12 (10 years ago)

Author:

Fran Boon

Comment:

Remote Access

InstallationGuidelines/PostgreSQL

@@ -264 +264 @@
 }}}
 
+== Rewmote Access ==
+Say that you want to provide access for an external reporting tool.
+
+Add the user account:
+{{{
+su postgres
+psql
+CREATE USER reporter WITH PASSWORD 'mypassword';
+\q
+exit
+su -c - postgres "psql -q -d sahana -c 'GRANT CONNECT ON DATABASE sahana TO reporter;'"
+su -c - postgres "psql -q -d sahana -c 'GRANT SELECT ON ALL TABLES IN SCHEMA public TO reporter;'"
+}}}
+
+Allow remote access:
+{{{
+vim /etc/postgresql/9.4/main/postgresql.conf
+listen_addresses = '*'
+
+vim /etc/postgresql/9.4/main/pg_hba.conf
+host    sahana          reporter        x.x.x.x/32          md5
+
+/etc/init.d/postgresql restart
+}}}
+
+NB Also remember any network firewll, e.g. on Amazon EC2, amend the Security Group.
+
 == Troubleshooting ==