Hello all,

I would like to install Silverstripe on a Postgresql database.

I have downloaded the unreleased module (http://silverstripe.org/postgresql-module/) but didn't manage to install it (I am lacking documentation).

Could you help me to start ?

Thank you in advance.

Hi,

I am trying to do the same thing. This is what I figured out sofar.
Put "PostgreSQLDatabase.php" file into "SilverStripe\sapphire\core\model". This is where "MySQLDatabase.php" is.
Second, you have to replace the file "config-form.html" in "SilverStripe\" with "http://open.silverstripe.com/raw-attachment/ticket/3362/config-form-pg.html"
Last, "install.php" has to be replaced as well but I cannot find a replacement file for PostgreSQL. I guess we have to wait a developer to write it cause I do not know any SQL stuff.
I hope this shed some light.

Hey Geoff, I was under the impression that the postgres version was not yet fully funcitonal. At least in my experience, I was unable to add new page types reliably - they simple didn't seem to get built.

Should we be adding tickets if we find bugs in the postgres module?

Hello All,

Since I am really interested in installing SilverStripe on a Postgresql database, I will share any information, patches,...

Thank you for your answers.

Where do i get a template for mysite/_config.php

currently i have this:
<?php

global $project;
$project = 'mysite';

global $database;
$database = "";

require_once("conf/ConfigureFromEnv.php");

PostgreSQLDatabase::set_connection_charset('utf8');

// This line set's the current theme. More themes can be
// downloaded from http://www.silverstripe.com/themes/
SSViewer::set_theme('blackcandy');

?>

but install.php is still asking for MySQL settings, not Postgres

As far as I know the installer has not yet been updated to support multiple databases (postgres and mssql support are both still alpha code). You would have to bypass the installer.php (by just deleting that file and setting your configuration in your _ss_environment.php file (or if you do not have one your mysite/_config file)

Information on setting your site up using _ss_environment.php is available here and an example mysite/_config.php file is available here

I've found the undocumented formula:

Unpack the module at the top level of the SilverStripe tree (parallel to sapphire).
Rename the unpacked folder to postgresql