Last modified: 2010-05-15 15:37:54 UTC
Hi, I've made a patch to have better support for PostgreSQL. With this patch atleast the installer and basic editing should work. I'll attach the patch shortly
Created attachment 372 [details] patch to get the installer working
Created attachment 373 [details] SQL script to add tsearch2 Should be placed in maintenance/postgresql/tsearch2.sql
Can this be merged with the suggestions and patches at bug 385 and bug 1295 ?
... or it it better to keep each mediawiki version tracked & patched separately?
The patch to patch-userlevels-defaultgroups.sql looks like it would break it on MySQL, which does not recognize double-quotes as valid for quoting table names. You should create a separate file for PostgreSQL.
Be careful, to make installer work properly it is important to take a look at pg_hba.conf file. You may have to provide access correctly. To test you can su www-data user and execute this command: psql -U adminUser -W -h `hostname` -l and when psql ask type your password, then you must get databases list... else reconfigure your pg_hba.conf file and retry. Authentication must be «MD5».
In reply to Brion's comment (#5): Why not turn on ANSI_QUOTES (sp?) for MySQL? As far as I understand, the way MySQL does quoting could be considered broken anyway.
*** This bug has been marked as a duplicate of 385 ***
