I just discovered that the schema_post.sql script only works on Postgres 8.2. Attached the new file that is also compatible with earlier versions of PG. I'm sorry ... -Rudolf. On Feb 7, 2007, at 5:01 PM, Rudolf van der Leeden wrote:
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
<schema_pre.sql>
<schema_post.sql>