Page MenuHomePhabricator

Installer postgresql support
Closed, ResolvedPublic

Description

Author: kurt

Description:
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


Version: 1.5.x
Severity: normal

Details

Reference
bz1709

Revisions and Commits

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:15 PM
bzimport set Reference to bz1709.
bzimport added a subscriber: Unknown Object (MLST).

kurt wrote:

patch to get the installer working

Attached:

kurt wrote:

SQL script to add tsearch2

Should be placed in maintenance/postgresql/tsearch2.sql

Attached:

zigger wrote:

Can this be merged with the suggestions and patches at bug 385 and bug 1295 ?

zigger wrote:

... 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.

toffe wrote:

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».

hfricke wrote:

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 ***
epriestley added a commit: Unknown Object (Diffusion Commit).Mar 4 2015, 8:14 AM
epriestley added a commit: Unknown Object (Diffusion Commit).Mar 4 2015, 8:22 AM
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.