aboutsummaryrefslogtreecommitdiffstats
path: root/docs/install/database.md
diff options
context:
space:
mode:
authorMatthew Somerville <matthew-github@dracos.co.uk>2018-09-27 14:56:52 +0100
committerMatthew Somerville <matthew-github@dracos.co.uk>2018-09-27 14:56:52 +0100
commitb3fea58c6f9a29ec5fb428d82c25e3a82ac962af (patch)
treef7b79502c8bcbc158451c205944ee8d337750f8e /docs/install/database.md
parent371927debffc6bb42d8d86a90afc715d1d837e74 (diff)
Move docs from gh-pages branch.
Diffstat (limited to 'docs/install/database.md')
-rw-r--r--docs/install/database.md36
1 files changed, 36 insertions, 0 deletions
diff --git a/docs/install/database.md b/docs/install/database.md
new file mode 100644
index 000000000..f282c8985
--- /dev/null
+++ b/docs/install/database.md
@@ -0,0 +1,36 @@
+---
+layout: page
+title: Database troubleshooting
+---
+
+# Database user access control
+
+<p class="lead">
+ These instructions are for Debian &mdash; do consult the PostgreSQL
+ documentation if you are having trouble at this stage.
+</p>
+
+At this point you might need to configure PostgreSQL to allow password-based
+access to the `fms` database as the user `fms` from using Unix-domain sockets.
+Edit the file `/etc/postgresql/8.4/main/pg_hba.conf` and add as the
+first line:
+
+ local fms fms md5
+
+You will then need to restart PostgreSQL with:
+
+ $ sudo /etc/init.d/postgresql restart
+
+If you want to access the database from the command line, you can add
+the following line to `~/.pgpass`:
+
+ localhost:*:fms:fms:somepassword
+
+Then you should be able to access the database with:
+
+ $ psql -U fms fms
+
+## Configuration
+
+When you've got everything working, you'll need to update the
+[database config settings]({{ "/customising/config/#fms_db_host" | relative_url }}).