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 <vanderleeden(a)logicunited.com> 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
vanderleeden(a)logicunited.com
Attachments:
- schema_pre.sql
- schema_post.sql
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page:
http://www.objectweb.org/wws
--
Best regards,
Xin