summaryrefslogtreecommitdiff
path: root/INSTALL.pgsql.txt
diff options
context:
space:
mode:
Diffstat (limited to 'INSTALL.pgsql.txt')
-rw-r--r--INSTALL.pgsql.txt47
1 files changed, 11 insertions, 36 deletions
diff --git a/INSTALL.pgsql.txt b/INSTALL.pgsql.txt
index 700111608..64847763f 100644
--- a/INSTALL.pgsql.txt
+++ b/INSTALL.pgsql.txt
@@ -1,31 +1,16 @@
// $Id$
-CONTENTS OF THIS FILE
----------------------
-
- * Introduction
- * Installation and configuration:
- - Database and user creation
- - Drupal schema loading
-
-INTRODUCTION
-------------
-
-This file describes how to create a PostgreSQL database for Drupal.
-
-If you control your databases through a web-based control panel,
-check its documentation, as the following instructions are for the
-command line only.
-
-INSTALLATION AND CONFIGURATION
+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 setup
- (e.g. by your host) or you want to create new user for use with Drupal
- only. The following command creates a new user named "username" and
- asks for a password for that user:
+ This step is only necessary if you don't already have a user setup (e.g.
+ by your host) or you want to create 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-adduser --no-createdb username
@@ -33,21 +18,11 @@ INSTALLATION AND CONFIGURATION
2. CREATE THE DRUPAL DATABASE
- This step is only necessary if you don't already have a database
- setup (e.g. by your host) or you want to create new database for
- use with Drupal only. The following command creates a new database
- named "databasename", which is owned by previously created "username":
+ This step is only necessary if you don't already have a database setup (e.g.
+ by your host) or you want to create new database for use with Drupal only.
+ The following command creates a new database named "databasename", which is
+ owned by previously created "username":
createdb --encoding=UNICODE --owner=username databasename
If everything works correctly, you'll see a "CREATE DATABASE" notice.
- Note that the database must be created with UTF-8 (Unicode) encoding.
-
-3. LOAD THE DRUPAL DATABASE SCHEMA
-
- Once the database has been created, load the required tables into it:
-
- psql -q -f database/database.pgsql databasename username
-
- If everything works correctly, you won't see any messages.
-