Bug#472987: [Pkg-mediawiki-devel] Bug#472987: mediawiki: Dependency not correct for usage with postgresql
Coin,
Romain Beauxis [EMAIL PROTECTED] writes:
Would a dependency on postgresql-contrib be sufficent ? Also, it makes the
whole thing a bit more complicated, since it's a logical constraint of the
type: mysql OR (postgresq AND postgresql-contrib) so I might have to add a
dummy package for that...
It would not because tsearch2 is a bit difficult to install (you need to
add special tables and functions, and to initialize indexes). It should
be easier in 8.3, as it is now included in the main program. Moreover,
on my MW installation with PG, i noticed MW is not inserting new data
with the proper special index info, so searching new material is not
working ; a special manipulation is needed regulary, but this is only
mere workaround:
UPDATE pagecontent SET textvector = NULL;
UPDATE page SET titlevector = NULL;
UPDATE pagecontent SET textvector = to_tsvector('default',old_text)
WHERE old_id IN (SELECT rev_text_id FROM revision, page WHERE
rev_id=page_latest AND page_is_redirect=0 );
UPDATE page SET titlevector = to_tsvector('default',page_title) WHERE
page_is_redirect=0;
and you can then improve search speed with:
REINDEX INDEX ts2_page_text;
REINDEX INDEX ts2_page_title;
but fact is the condition on old_id is not working well, so you can just
drop it, but you may find older versions of the documents in a
search. So, this is work in progress for me, and we need to write a
proper patch for MW before looking for a way to have it installed
easily.
--
Marc Dequènes
Homepage: http://www.proformatique.com/
Proformatique - 67 rue Voltaire - 92800 Puteaux
Tel. : 01 41 38 99 64 - Fax. : 01 41 38 99 70
pgpjepbtjEyc0.pgp
Description: PGP signature
Bug#472987: [Pkg-mediawiki-devel] Bug#472987: mediawiki: Dependency not correct for usage with postgresql
Hi Marc, good to hear from you ! Le Friday 28 March 2008 14:50:50 Marc Dequènes, vous avez écrit : So, this is work in progress for me, and we need to write a proper patch for MW before looking for a way to have it installed easily. Question here is, again: will MW be ready for using pgsql for next stable release ? Perhaps a correct trade-off would be to put pgsql in suggests and mysql in recommends ? Romain -- Could not recognize the faces standing over me; They were all dressed in uniforms of brutality.
Bug#472987: [Pkg-mediawiki-devel] Bug#472987: mediawiki: Dependency not correct for usage with postgresql
reopen 472987 severity important thanks [ adjusting severity; might be a kind of panic reaction ] [ adding postgresql maintainers to CC for their input ] Hi Romain! Thanks for the very fast answer! * Romain Beauxis [EMAIL PROTECTED] [080327 17:04]: It seems to me that recommending postgresql-8.1 (or postgresql as 1:1.12.0-1 thankfully does) isn't enough, since you need not only to have a postgresql server, but also tspeak2 which seems to be in the respective postgresql-contrib package. Please try to read previous reports.. This was fixed with the latest 1.12.0 upload.. Small correction to my last message: s/tsepak2/tsearch2/ ;) Actually I did, and I think you refer to: * Changed postgresql recommends to postgresql package Closes: #469582 This allows mediawiki to be used with any version of the postgresql-Server, which is good. However: To run mediawiki on a postgresql-Server you seem to need tsearch2, which is shipped in a seperate package, namely postgresql-contrib. Without that package beeing installed, it just doesn't work. Beeing not really deep in postgresql myself, I'm not really sure, if changing the recommends from postgresql to postgresql-contrib is okay; postgresql-contrib depends on the proper postsql package, so the server would be pulled in, too. Maybe the postgresql maintainer can say something about that? It would also be cool, if it could be further documented, on how to enable this feature (one needs to do something like psql wikidb /usr/share/postgresql/8.1/contrib/tsearch2.sql, after running config/index.php, but I'm not entirely sure, since I'm stuck with the error message: »Attempting to set default tsearch2 locale to de_DE.UTF-8... Warning: pg_query() [function.pg-query]: Query failed: FEHLER: keine Berechtigung für Relation pg_ts_cfg in /usr/share/mediawiki/includes/DatabasePostgres.php on line 544 FAILED. Please make sure that the locale in pg_ts_cfg for default is set to de_DE.UTF-8« after running the above command.) Hey, I don't know anything related to postgre so I can hardly help.. Got it working :) Seems like the the configure script is not yet really working; after doing an GRANT ALL on pg_ts_cfg TO wikiadmin; the config script finished, and now I have a really nice mediawiki using my postgres-Database. However, the package is team-maintained, but I 'm currently the only member, so I would kindly accept new contributions/contributors :-) I'll set it on my todo-List, promised, but it might take some time for me to get back to you, since I'm quite busy at the moment. Yours sincerely, Alexander signature.asc Description: Digital signature
Bug#472987: [Pkg-mediawiki-devel] Bug#472987: mediawiki: Dependency not correct for usage with postgresql
Le Thursday 27 March 2008 17:59:16 Alexander Schmehl, vous avez écrit : However: To run mediawiki on a postgresql-Server you seem to need tsearch2, which is shipped in a seperate package, namely postgresql-contrib. Without that package beeing installed, it just doesn't work. Fine, sorry I had missed this point. I have added Marc to the discussion, he is my pgsql expert on mediawiki... Would a dependency on postgresql-contrib be sufficent ? Also, it makes the whole thing a bit more complicated, since it's a logical constraint of the type: mysql OR (postgresq AND postgresql-contrib) so I might have to add a dummy package for that... Romain -- Could not recognize the faces standing over me; They were all dressed in uniforms of brutality.
