INSTALL.pgsql.txt 993 Bytes
Newer Older
1 2
// $Id$

3
CREATE THE PostgreSQL DATABASE
4 5
------------------------------

6 7
Note that the database must be created with UTF-8 (Unicode) encoding.

8
1. CREATE DATABASE USER
9

10
   This step is only necessary if you don't already have a user set up (e.g.
11 12 13
   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:
14

15
     createuser --pwprompt --encrypted --no-createrole --no-createdb username
16

17
   If there are no errors then the command was successful
18 19

2. CREATE THE DRUPAL DATABASE
20

21
   This step is only necessary if you don't already have a database set up (e.g.
22 23 24
   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":
25

26
     createdb --encoding=UTF8 --owner=username databasename
27

28
   If there are no errors then the command was successful