XWiki 0.9 to 1.0Beta Postgres Database Upgrade using DATA only

[Rudolf van der Leeden]

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 at logicunited.com

Attachments:
   - schema_pre.sql
   - schema_post.sql


-------------- next part --------------
A non-text attachment was scrubbed...
Name: schema_pre.sql
Type: application/octet-stream
Size: 13512 bytes
Desc: not available
Url : http://lists.xwiki.org/pipermail/users/attachments/20070207/16a225e8/attachment-0002.obj 
-------------- next part --------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: schema_post.sql
Type: application/octet-stream
Size: 949 bytes
Desc: not available
Url : http://lists.xwiki.org/pipermail/users/attachments/20070207/16a225e8/attachment-0003.obj