Permalink
Cannot retrieve contributors at this time
Name already in use
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
drupal/INSTALL.pgsql.txt
Go to fileThis commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
44 lines (30 sloc)
1.83 KB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 want to create a 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 DRUPAL DATABASE | |
This step is only necessary if you don't already have a database set up | |
(e.g., by your host) or want to create a new database for use with Drupal | |
only. The following command creates a new database named 'databasename', | |
which is owned by the previously created 'username': | |
createdb --encoding=UTF8 --owner=username databasename | |
If there are no errors, then the command was successful. | |
3. CREATE SCHEMA OR SCHEMAS (Optional advanced step) | |
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 run inside of, or | |
specify tables that are shared inside of a separate schema. Drupal will not | |
create schemas for you. In fact, the user that Drupal runs as should not be | |
allowed to do this. You'll need to execute the SQL below as a superuser, | |
replace 'username' with the username that Drupal uses to connect to | |
PostgreSQL, and replace 'schema_name' with a schema name you wish to use, | |
such as 'shared': | |
CREATE SCHEMA schema_name AUTHORIZATION username; | |
Do this for as many schemas as you need. See default.settings.php for | |
instructions on how to set which tables use which schemas. |