[Summary view] [Print] [Text view]

   1  
   2  CREATE THE PostgreSQL DATABASE
   3  ------------------------------
   4  
   5  Note that the database must be created with UTF-8 (Unicode) encoding.
   6  
   7  1. CREATE DATABASE USER
   8  
   9     This step is only necessary if you don't already have a user set up (e.g.
  10     by your host) or you want to create new user for use with Drupal only. The
  11     following command creates a new user named "username" and asks for a
  12     password for that user:
  13  
  14       createuser --pwprompt --encrypted --no-adduser --no-createdb username
  15  
  16     If everything works correctly, you'll see a "CREATE USER" notice.
  17  
  18  2. CREATE THE DRUPAL DATABASE
  19  
  20     This step is only necessary if you don't already have a database set up (e.g.
  21     by your host) or you want to create new database for use with Drupal only.
  22     The following command creates a new database named "databasename", which is
  23     owned by previously created "username":
  24  
  25       createdb --encoding=UNICODE --owner=username databasename
  26  
  27     If everything works correctly, you'll see a "CREATE DATABASE" notice.