4945 Posts in 17807 Topics by 1494 members
Page: 1 2
|Go to End||Next >|
25 January 2009 at 9:13pm
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.
29 January 2009 at 8:34am
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.
Core Development Team
29 January 2009 at 3:40pm
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.
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?
Core Development Team
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.
30 January 2009 at 10:00am
Since I am really interested in installing SilverStripe on a Postgresql database, I will share any information, patches,...
Thank you for your answers.
26 July 2009 at 7:57pm
Where do i get a template for mysite/_config.php
currently i have this:
$project = 'mysite';
$database = "";
// This line set's the current theme. More themes can be
// downloaded from http://www.silverstripe.com/themes/
but install.php is still asking for MySQL settings, not Postgres
26 July 2009 at 8:10pm Last edited: 26 July 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)
Page: 1 2
|Go to Top||Next >|