From b91bc101a0a3c8227b225ce557954f6a1e654ed3 Mon Sep 17 00:00:00 2001 From: Aleksander Machniak Date: Mon, 27 May 2013 12:43:54 +0200 Subject: Simplify instruction of database initialization for Postgres --- INSTALL | 13 ++++--------- 1 file changed, 4 insertions(+), 9 deletions(-) (limited to 'INSTALL') 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 -- cgit v1.2.3