Last modified: 2010-05-15 15:37:54 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T3709, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 1709 - Installer postgresql support
Installer postgresql support
Status: RESOLVED DUPLICATE of bug 385
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
All All
: Normal normal with 3 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
: patch
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2005-03-18 20:39 UTC by Kurt Roeckx
Modified: 2010-05-15 15:37 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

patch to get the installer working (30.42 KB, patch)
2005-03-18 20:49 UTC, Kurt Roeckx
SQL script to add tsearch2 (19.04 KB, text/plain)
2005-03-18 20:52 UTC, Kurt Roeckx

Description Kurt Roeckx 2005-03-18 20:39:43 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
Comment 1 Kurt Roeckx 2005-03-18 20:49:38 UTC
Created attachment 372 [details]
patch to get the installer working
Comment 2 Kurt Roeckx 2005-03-18 20:52:39 UTC
Created attachment 373 [details]
SQL script to add tsearch2

Should be placed in maintenance/postgresql/tsearch2.sql
Comment 3 Zigger 2005-03-19 01:43:55 UTC
Can this be merged with the suggestions and patches at bug 385 and bug 1295 ?
Comment 4 Zigger 2005-03-19 01:46:07 UTC
... or it it better to keep each mediawiki version tracked & patched separately?

Comment 5 Brion Vibber 2005-03-19 12:18:54 UTC
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.
Comment 6 Christophe Truffier 2005-04-26 12:39:34 UTC
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».
Comment 7 Harald Fricke 2005-10-07 09:51:38 UTC
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
Comment 8 Brion Vibber 2005-10-29 07:21:37 UTC

*** This bug has been marked as a duplicate of 385 ***

Note You need to log in before you can comment on or make changes to this bug.