summaryrefslogtreecommitdiff
path: root/kolab.org/www/drupal-7.26/INSTALL.pgsql.txt
diff options
context:
space:
mode:
Diffstat (limited to 'kolab.org/www/drupal-7.26/INSTALL.pgsql.txt')
-rw-r--r--kolab.org/www/drupal-7.26/INSTALL.pgsql.txt44
1 files changed, 44 insertions, 0 deletions
diff --git a/kolab.org/www/drupal-7.26/INSTALL.pgsql.txt b/kolab.org/www/drupal-7.26/INSTALL.pgsql.txt
new file mode 100644
index 0000000..8fe8043
--- /dev/null
+++ b/kolab.org/www/drupal-7.26/INSTALL.pgsql.txt
@@ -0,0 +1,44 @@
+
+CREATE THE PostgreSQL DATABASE
+------------------------------
+
+Note that the database must be created with UTF-8 (Unicode) encoding.
+
+1. CREATE DATABASE USER
+
+ This step is only necessary if you don't already have a user set up (e.g., by
+ your host), or want to create a new user for use with Drupal only. The
+ following command creates a new user named 'username' and asks for a password
+ for that user:
+
+ createuser --pwprompt --encrypted --no-createrole --no-createdb username
+
+ If there are no errors, then the command was successful.
+
+2. CREATE DRUPAL DATABASE
+
+ This step is only necessary if you don't already have a database set up
+ (e.g., by your host) or want to create a new database for use with Drupal
+ only. The following command creates a new database named 'databasename',
+ which is owned by the previously created 'username':
+
+ createdb --encoding=UTF8 --owner=username databasename
+
+ If there are no errors, then the command was successful.
+
+3. CREATE SCHEMA OR SCHEMAS (Optional advanced step)
+
+ Drupal will run across different schemas within your database if you so wish.
+ By default, Drupal runs inside the 'public' schema but you can use $db_prefix
+ inside settings.php to define a schema for Drupal to run inside of, or
+ specify tables that are shared inside of a separate schema. Drupal will not
+ create schemas for you. In fact, the user that Drupal runs as should not be
+ allowed to do this. You'll need to execute the SQL below as a superuser,
+ replace 'username' with the username that Drupal uses to connect to
+ PostgreSQL, and replace 'schema_name' with a schema name you wish to use,
+ such as 'shared':
+
+ CREATE SCHEMA schema_name AUTHORIZATION username;
+
+ Do this for as many schemas as you need. See default.settings.php for
+ instructions on how to set which tables use which schemas.