From b91bc101a0a3c8227b225ce557954f6a1e654ed3 Mon Sep 17 00:00:00 2001
From: Aleksander Machniak <alec@alec.pl>
Date: Mon, 27 May 2013 06:43:54 -0400
Subject: [PATCH] Simplify instruction of database initialization for Postgres

---
 INSTALL |   13 ++++---------
 1 files changed, 4 insertions(+), 9 deletions(-)

diff --git a/INSTALL b/INSTALL
index 3abf0d1..3876f63 100644
--- a/INSTALL
+++ b/INSTALL
@@ -116,17 +116,12 @@
 simple steps, which have to be done as the postgres system user (or
 which ever is the database superuser):
 
-$ createuser roundcube
+$ createuser -P roundcube
 $ createdb -O roundcube -E UNICODE roundcubemail
-$ psql roundcubemail
+$ psql -U roundcube -f SQL/postgres.initial.sql roundcubemail
 
-roundcubemail =# ALTER USER roundcube WITH PASSWORD 'the_new_password';
-roundcubemail =# \c - roundcube
-roundcubemail => \i SQL/postgres.initial.sql
-
-All this has been tested with PostgreSQL 8.x and 7.4.x. Older
-versions don't have a -O option for the createdb, so if you are
-using that version you'll have to change ownership of the DB later.
+Note: in some system configurations you might need to add '-U postgres' to
+createuser and createdb commands.
 
 
 * Microsoft SQL Server

--
Gitblit v1.9.1