(Repost) XWiki 0.9 to 1.0Beta Postgres Database Upgrade using DATA only

(This is a repost of my posting on 2007-Feb-07 with the same title and content) For those running XWiki 0.9 on a Postgres database, the following database upgrade procedure might be useful. STEP (1) Backup the existing database using pg_dump with --data_only and --attribute-inserts STEP (2) Create a new database with the XWiki 1.0Beta schema (schema_pre.sql) STEP (3) Restore the data into the new database STEP (4) Update the new database schema to be full compatible with the 1.0Beta schema (schema_post.sql) STEP (5) Start XWiki 1.0B3 The detailed procedure is outlined in schema_pre.sql. Please report any success or failure so that the community can learn from your experience and we can improve the tools. Good luck! Rudolf VanderLeeden vanderleeden(a)logicunited.com Attachments: - schema_pre.sql - schema_post.sql