[drupal-devel] [task] Installation instructions for PostgreSQL users

[Smirnov]

Issue status update for http://drupal.org/node/25792

 Project:      Drupal
-Version:      4.6.0
+Version:      cvs
 Component:    postgresql database
 Category:     tasks
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  Smirnov
 Updated by:   Smirnov
-Status:       active
+Status:       patch
 Attachment:   http://drupal.org/files/issues/INSTALL.txt.patch(install only) (4.48 KB)

Updated INSTALL.txt against HEAD, also made it so the instructions
pertain to installing to the "public" schema by default (and left a
notice on there for people to edit database.pgsql if they need to do
otherwise). The previous patches can now be safely ignored (esp. since
they were for 4.6.1).




Smirnov



Previous comments:
------------------------------------------------------------------------

June 26, 2005 - 08:41 : Smirnov

Attachment: http://drupal.org/files/issues/INSTALL.txt.oldnew.patch (4.39 KB)

Although installing Drupal with PostgreSQL is rather straight forward,
there are a few stumbling blocks (needing to load a language into the
database and not using the public schema, as well as there being zero
instructions):


I have added instructions to /INSTALL.txt/ on how to load up the SQL
scheme into PostgreSQL, and I have edited /database/database.pgsql/ so
that it is easy to install drupal into any schema. As a result, users
can now for example install Drupal into database drupal, schema drupal
(with the functions in public). This means they could use different
modules for different schemas if they wanted to. 


The instructions include:


* Creating a database with /createdb/
* Loading up plpgsql language with /createlang/
* Inserting all the SQL data into the schema of choice
* Changing /$db_prefix/ to reflect the schema


------------------------------------------------------------------------

June 26, 2005 - 08:42 : Smirnov

Attachment: http://drupal.org/files/issues/database.pgsql.oldnew.patch (588 bytes)

Attached the /database/database.pgsql/ patch