You are here

test

M!N! Sh3LL
Uname : Linux charybdis.irsot.net 2.6.32-642.11.1.el6.centos.plus.x86_64 #1 SMP Sat Nov 19 13:48:44 UTC 2016 x86_64
PWD : /home/www/irsot.ru/content
Server IP : 78.107.80.41
Directory : /home/www/irsot.ru/content/

[Home] [System Details] [Kill Me]
Current File:~$ /home/www/irsot.ru/content/INSTALL.pgsql.txt


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.