From: Krabina B. <kr...@kd...> - 2013-05-07 15:17:12
|
Dear all, I am on a project with the Vienna City Administration using SMW for the first time. As their strategic choice for databases is PostgreSQL (not MySQL) the might consider testing SMW on their environment (RedHat 6 Enterprise, PostgreSQL 9.1.6). Unfortunately, I just read that the PostgreSQL support seems to be broken altogehter: http://semantic-mediawiki.org/wiki/PostgreSQL https://bugzilla.wikimedia.org/show_bug.cgi?id=42659 Can anyone help us out? Does the patch work? Is the database problem something you can fix during installation or are more problems to be expected once you are running SMW? What is the reason for the broken PostgreSQL support? As I don't think it is a good idea to do the project with SMW 1.7.1 it would be important to get some more insight and community support in order to get this working again. What were your experiences with PostgreSQL support in earlier SMW versions? Best regards, Bernhard |
From: Jeroen De D. <jer...@gm...> - 2013-05-07 17:07:20
|
Hey, I would not run with PostgreSQL until there is decent support for this on smw master AND there are tests on our CI system to ensure things don't break. Right now support for this is very flaky and fixing some random errors is not going to fix that. If you really want to run on PostgreSQL, the best thing to do is probably throw some dev resources at getting PostgreSQL fixed in SMW itself (not just the code you have checked out). Once the main issues are fixed and this is probably integrated in our CI, we can easily maintain it and then it ought to not break in the next release (as has happened in the past). I spend some time doing exactly that for SQLite, for which we now have full support. PostgreSQL might however be a bit more tricky. Cheers -- Jeroen De Dauw http://www.bn2vs.com Don't panic. Don't be evil. -- |