[PATCH] Document password-based pgsql login

[martin f. krafft]

As an alternative to ident-based authentication for PostgreSQL, one can
use password-based authentication. This patch adds the alternative to
the docs.

Signed-off-by: martin f. krafft <madduck at madduck.net>
---
 docs/INSTALL |   27 ++++++++++++++++++++++++---
 1 files changed, 24 insertions(+), 3 deletions(-)

diff --git a/docs/INSTALL b/docs/INSTALL
index dd31f32..80c5872 100644
--- a/docs/INSTALL
+++ b/docs/INSTALL
@@ -29,7 +29,10 @@ in brackets):
     user that your mail server runs as). On Ubuntu these are
     www-data and nobody, respectively.
 
-    For PostgreSQL
+    As an alternative, you can use password-based login and a single database
+    account. This is described further down.
+
+    For PostgreSQL (ident-based)
 
         $ createdb patchwork
         $ createuser www-data
@@ -38,8 +41,24 @@ in brackets):
 	- postgres uses the standard UNIX authentication, so these users
 	  will only be accessible for processes running as the same username.
 	  This means that no passwords need to be set.
+   
+    For PostgreSQL (password-based)
+
+        $ createuser -PE patchwork
+        $ createdb -O patchwork patchwork
+
+        Once that is done, you need to tell Django about the new Database
+        settings, using local_settings.py (see below) to override the defaults
+        in settings.py:
+
+        DATABASE_ENGINE = 'postgresql_psycopg2'
+        DATABASE_NAME = 'patchwork'
+        DATABASE_USER = 'patchwork'
+        DATABASE_PASSWORD = 'my_secret_password
+        DATABASE_HOST = 'localhost'
+        DATABASE_PORT = ''
 
-     For MySQL:
+    For MySQL:
         $ mysql
 	> CREATE DATABASE 'patchwork';
         > CREATE USER 'www-data'@'localhost' IDENTIFIED BY '<password>';
@@ -120,7 +139,9 @@ in brackets):
 	 cd apps/
 	 PYTHONPATH=../lib/python ./manage.py syncdb
 
-	And add privileges for your mail and web users:
+	And add privileges for your mail and web users. This is only needed if
+	you use the ident-based approach. If you use password-based database
+	authentication, you can skip this step.
 
 	Postgresql:
 	  psql -f lib/sql/grant-all.postgres.sql patchwork
-- 
1.5.6.5