diff options
author | Matthew Somerville <matthew-github@dracos.co.uk> | 2018-09-27 14:56:52 +0100 |
---|---|---|
committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2018-09-27 14:56:52 +0100 |
commit | b3fea58c6f9a29ec5fb428d82c25e3a82ac962af (patch) | |
tree | f7b79502c8bcbc158451c205944ee8d337750f8e /docs/install/database.md | |
parent | 371927debffc6bb42d8d86a90afc715d1d837e74 (diff) |
Move docs from gh-pages branch.
Diffstat (limited to 'docs/install/database.md')
-rw-r--r-- | docs/install/database.md | 36 |
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 — 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 }}). |