1 // $Id: INSTALL.pgsql.txt 144 2007-03-28 07:52:20Z thierry $
7 * Installation and configuration:
8 - Database and user creation
9 - Drupal schema loading
14 This file describes how to create a PostgreSQL database for Drupal.
16 If you control your databases through a web-based control panel,
17 check its documentation, as the following instructions are for the
20 INSTALLATION AND CONFIGURATION
21 ------------------------------
23 1. CREATE DATABASE USER
25 This step is only necessary if you don't already have a user setup
26 (e.g. by your host) or you want to create new user for use with Drupal
27 only. The following command creates a new user named "username" and
28 asks for a password for that user:
30 createuser --pwprompt --encrypted --no-adduser --no-createdb username
32 If everything works correctly, you'll see a "CREATE USER" notice.
34 2. CREATE THE DRUPAL DATABASE
36 This step is only necessary if you don't already have a database
37 setup (e.g. by your host) or you want to create new database for
38 use with Drupal only. The following command creates a new database
39 named "databasename", which is owned by previously created "username":
41 createdb --encoding=UNICODE --owner=username databasename
43 If everything works correctly, you'll see a "CREATE DATABASE" notice.
44 Note that the database must be created with UTF-8 (Unicode) encoding.
46 3. LOAD THE DRUPAL DATABASE SCHEMA
48 Once the database has been created, load the required tables into it:
50 psql -q -f database/database.pgsql databasename username
52 If everything works correctly, you won't see any messages.