Last modified: 2010-05-15 15:37:54 UTC
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
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
*** This bug has been marked as a duplicate of 385 ***