On 04/04/2012 06:18 PM, Ramon Gomes Brandão wrote:
Hello,
I'm trying to migrate from XE 3.1-M2 to 3.5 on Postgresql 9.1, and I've followed what's described on the forums regarding the migration problem, but no success. Adjusting the xwiki.hbm.xml file succeeded for migration, but the migration broke all pages's attachments due to "Bad value for type long" in attachment's contents. So, what's described in http://jira.xwiki.org/browse/XWIKI-7564 still does not work. I've tried also the jdbc adjustments in hibernate.cfg.xml, whitout success.
Could you please help us, Postgresql users, to find the right solution on this issue or point us to the right path?
Hi Ramon, users, The upcoming XWiki 3.5.1 should work well. Your options now are: - wait for 3.5.1 to be released (should be in a few days) - use the latest 3.5 snapshot - use 3.5 and manually apply the fixes for PostgreSQL: -- use https://raw.github.com/xwiki/xwiki-platform/master/xwiki-platform-core/xwiki... as the mapping file (don't forget to enable it in hibernate.cfg.xml) -- run this script on the database, or each database if you're running a virtual wiki farm with more wikis: https://raw.github.com/xwiki/xwiki-platform/master/xwiki-platform-core/xwiki... Personally I'd recommend waiting for 3.5.1, since it's the safest approach.
Thanks in advance.
Regards, Ramon Brandao
<http://jira.xwiki.org/browse/XWIKI-7564>
Em 22/02/2012 19:15, Vincent Massol escreveu:
Hi Dirk,
On Feb 22, 2012, at 9:28 PM, H.-Dirk Schmitt wrote:
Hello!
has anybody a recent xwiki (3.4 or 3.5) running with a postgresql database?
I tried to migrate from 3.0 --> 3.4 but running in some problems:
http://jira.xwiki.org/browse/XWIKI-7537 http://jira.xwiki.org/browse/XWIKI-7564
From my point of view is xwiki currently not usable with postgresql. It seems it works fine if you install XE 3.4 but what's not working is the migration. Apparently Caleb has reproduced the issue but it works if we do what you reported (ie add the materialized clob typedef) but Caleb has found a strange warning in the logs which doesn't look too good (don't remember the exact log, something about some invalid revision) and we still need to look at that.
Strangely file attachment worked for Caleb when we migrated his wiki.
Someone (committer, contributor) need to work on this for 4.0 and 3.5.1… (I'm not committing right now since I'm pretty busy).
Thanks -Vincent
Best Regards,
H.-Dirk Schmitt
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Sergiu Dumitriu http://purl.org/net/sergiu/