Hi Rudolf , Many thanks! I find you change the data type of xwd_class_xml and xwd_archive from varchar to text. I think this should be the default hibernate mapping with new release publishing to avoid the error of importing xar files using postgres. On 3/5/07, Rudolf van der Leeden <[email protected]> wrote:

(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 [email protected]

Attachments: - schema_pre.sql - schema_post.sql

-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

-- Best regards, Xin