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
• bzimport | |
Mar 18 2005, 8:39 PM |
F1883: postgres.diff | |
Nov 21 2014, 8:15 PM |
F1884: tsearch2.sql | |
Nov 21 2014, 8:15 PM |
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
Unknown Object (Diffusion Commit) | |
Unknown Object (Diffusion Commit) |
Status | Subtype | Assigned | Task | |
---|---|---|---|---|
· · · | ||||
Invalid | None | T2384 [REPLACED BY TAG] PostgreSQL/pgsql support (tracking) | ||
Resolved | None | T3709 Installer postgresql support | ||
· · · |
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.