home | career | drupal | java | mac | mysql | perl | php | scala | uml | unix

Drupal example source code file (INSTALL.pgsql.txt)

This example Drupal source code file (INSTALL.pgsql.txt) is included in the DevDaily.com "Drupal Source Code Warehouse" project. The intent of this project is to help you "Learn Drupal by Example".

PHP - Drupal tags/keywords

create, database, drupal, for, if, schema, schemas, that, the, to, user, with, you

The INSTALL.pgsql.txt Drupal example source code

// $Id: INSTALL.pgsql.txt,v 1.9 2010/04/07 15:07:58 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

3. CREATE A SCHEMA OR SCHEMAS (Optional advanced)

  Drupal will run across different schemas within your database if you so wish.
  By default, Drupal runs inside the 'public' schema but you can use $db_prefix
  inside settings.php to define a schema for Drupal to inside of or specify tables
  that are shared inside of a separate schema. Drupal will not create schemas for
  you, infact the user that Drupal runs as should not be allowed to. You'll need
  execute the SQL below as a superuser (such as a postgres user) and replace
  'drupaluser' with the username that Drupal uses to connect to PostgreSQL with
  and replace schema_name with a schema name you wish to use such as 'shared':

    CREATE SCHEMA schema_name AUTHORIZATION drupaluser;

  Do this for as many schemas as you need. See default.settings.php for how to
  set which tables use which schemas.

Other Drupal examples (source code examples)

Here is a short list of links related to this Drupal INSTALL.pgsql.txt source code file:

new blog posts

"Drupal" is a registered trademark of Dries Buytaert.

my drupal tutorials and examples  

Copyright 1998-2016 Alvin Alexander, alvinalexander.com
All Rights Reserved.

Beginning in 2016, a portion of the proceeds from pages under the '/drupal-code-examples/' URI will be donated to charity.