I just wanted to let you know that I didn't have
serious problems going from XWiki 0.9.1252 to XWiki 1.0B3 with a Postgres
database.
Basically, I followed the instructions
in:
As reported earlier, you'll get an exception
("Could not execute JDBC batch update") connecting to XWiki 1.0B3 for the
first time.
Analyzing the error message in xwiki.log:
Batch entry 0 insert into xwikidoc (XWD_FULLNAME
…)
SQL ERROR: null value in
column "xwd_archive" violates not-null constraint
leads to an easy conclusion: remove the not-null
constraint from the xwd_archive column in the xwikidoc table.
The SQL statement is: ALTER TABLE xwikidoc ALTER COLUMN xwd_archive DROP
NOT NULL;
After running this SQL statement the connection was
done successfully and I could load the XAR file as described in the
instructions.
In my case, only one thing was different from the
old XWiki. All the memberships in XWikiAllGroup were gone. Only the ADMIN user
was a member. So I created a Ruby script to add all users to XWikiAllGroup in
the database. This can of course also be done manually.
I don't know if this works in all Postgres cases.
BTW, I did at the same time a database upgrade from
PG 8.1.3 to 8.2.1.
Rudolf VanderLeeden
SysAdmin
Logic United GmbH
(Germany)