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,

To get the Postgres module working, all you need to do is to download it and put the postgres directory in the root of your project (ie, alongside sapphire, cms etc).

Then you need to edit the _config.php file (or _ss_environment.php file) in your project, and change the 'MySQLDatabase' value to 'PostgreSQLDatabase' and also change the username and password where appropriate.

That should be all you need to do. Run /dev/build on your project and all the tables should be created.

One final note though: you need to manually create the database, since the script can't create a non-existent database at the moment. Also, I highly recommend running 8.3.x, since T-Search (when we eventually get it running) needs to be part of the Postgres installation.

Thanks for giving the Postgres module a try, and let us know if you have any problems or code to contribute.

Geoff

Well it's not 'fully functional', for instance, indexes don't work at all, and we need to figure out how to implement tsearch + all the other neat things that Postgres does.
However, as far as I know, all the (very) basic functionality does work, although I haven't tried everything.

If you find a problem, then PLEASE add a ticket under the postgres module. Patches can be added too, or you can email me code (geoff at silverstripe.com) if you prefer.

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