From ef3b7b60bbfbcd7b61e3a04797d110ee19fc4506 Mon Sep 17 00:00:00 2001 From: Martin Krafft Date: Sun, 31 Jan 2010 03:03:10 +0100 Subject: [PATCH] docs: Document password-based pgsql login 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 Signed-off-by: Jeremy Kerr --- docs/INSTALL | 27 ++++++++++++++++++++++++--- 1 file changed, 24 insertions(+), 3 deletions(-) diff --git a/docs/INSTALL b/docs/INSTALL index 0ed2cea..7a32434 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 @@ -39,7 +42,23 @@ in brackets): will only be accessible for processes running as the same username. This means that no passwords need to be set. - For MySQL: + 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: $ mysql > CREATE DATABASE 'patchwork'; > CREATE USER 'www-data'@'localhost' IDENTIFIED BY ''; @@ -119,7 +138,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 -- 2.39.2