summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAleksander Machniak <alec@alec.pl>2013-05-27 12:43:54 +0200
committerAleksander Machniak <alec@alec.pl>2013-05-27 12:43:54 +0200
commitb91bc101a0a3c8227b225ce557954f6a1e654ed3 (patch)
treee01e7c5e037af0984aa819b61629b52a0783baa0
parentcb7036c28a0481c183b72c8492ba1c981e2c9e34 (diff)
Simplify instruction of database initialization for Postgres
-rw-r--r--INSTALL13
1 files changed, 4 insertions, 9 deletions
diff --git a/INSTALL b/INSTALL
index 3abf0d198..3876f632c 100644
--- a/INSTALL
+++ b/INSTALL
@@ -116,17 +116,12 @@ To use Roundcube with PostgreSQL support you have to follow these
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