diff options
author | Aleksander Machniak <alec@alec.pl> | 2013-05-27 12:43:54 +0200 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2013-05-27 12:43:54 +0200 |
commit | b91bc101a0a3c8227b225ce557954f6a1e654ed3 (patch) | |
tree | e01e7c5e037af0984aa819b61629b52a0783baa0 | |
parent | cb7036c28a0481c183b72c8492ba1c981e2c9e34 (diff) |
Simplify instruction of database initialization for Postgres
-rw-r--r-- | INSTALL | 13 |
1 files changed, 4 insertions, 9 deletions
@@ -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 |