drupal/drupal/INSTALL.pgsql.txt

// $Id: INSTALL.pgsql.txt,v 1.7 2007/11/26 16:36:42 dries Exp $

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 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-createrole --no-createdb username

   If there are no errors then the command was successful

2. CREATE THE DRUPAL DATABASE

   This step is only necessary if you don't already have a database set up (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=UTF8 --owner=username databasename

   If there are no errors then the command was successful
1	// $Id: INSTALL.pgsql.txt,v 1.7 2007/11/26 16:36:42 dries Exp $
2
3	CREATE THE PostgreSQL DATABASE
4	------------------------------
5
6	Note that the database must be created with UTF-8 (Unicode) encoding.
7
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	by your host) or you want to create new user for use with Drupal only. The
12	following command creates a new user named "username" and asks for a
13	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	by your host) or you want to create new database for use with Drupal only.
23	The following command creates a new database named "databasename", which is
24	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