aboutsummaryrefslogtreecommitdiffstats
path: root/community/roundcubemail/roundcubemail-pgsql.post-install
diff options
context:
space:
mode:
Diffstat (limited to 'community/roundcubemail/roundcubemail-pgsql.post-install')
-rw-r--r--community/roundcubemail/roundcubemail-pgsql.post-install12
1 files changed, 12 insertions, 0 deletions
diff --git a/community/roundcubemail/roundcubemail-pgsql.post-install b/community/roundcubemail/roundcubemail-pgsql.post-install
new file mode 100644
index 0000000000..f46ba5b3e2
--- /dev/null
+++ b/community/roundcubemail/roundcubemail-pgsql.post-install
@@ -0,0 +1,12 @@
+#!/bin/sh
+
+cat >&2 <<EOF
+*
+* Create database for Roundcube and load the initialization script:
+*
+* su -l postgres
+* psql -c "CREATE ROLE roundcube PASSWORD 'top-secret' INHERIT LOGIN;"
+* psql -c "CREATE DATABASE roundcube OWNER roundcube ENCODING 'UTF-8';"
+* psql -U roundcube roundcube < /usr/share/webapps/roundcube/SQL/postgres.initial.sql
+*
+EOF