Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Installing SilverStripe on Postgresql database


Go to End
Reply


10 Posts   4606 Views

Avatar
argh

Community Member, 4 Posts

25 January 2009 at 9:13pm

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.

Avatar
StarCrescent

Community Member, 4 Posts

29 January 2009 at 8:34am

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.

Avatar
Geoff

Core Development Team, 8 Posts

29 January 2009 at 3:40pm

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

Avatar
Hamish

Community Member, 712 Posts

30 January 2009 at 8:28am

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?

Avatar
Geoff

Core Development Team, 8 Posts

30 January 2009 at 9:52am

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.

Avatar
argh

Community Member, 4 Posts

30 January 2009 at 10:00am

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.

Avatar
Shiny

Community Member, 7 Posts

26 July 2009 at 7:57pm

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

Avatar
Willr

Forum Moderator, 5513 Posts

26 July 2009 at 8:10pm

Edited: 26/07/2009 8:10pm

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)

Go to Top