XWiki 0.9 to 1.0Beta Postgres Database Upgrade using DATA only - schema_post.sql update

[Rudolf van der Leeden]

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.

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




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
> vanderleeden at logicunited.com
>
> Attachments:
>   - schema_pre.sql
>   - schema_post.sql
>
>
> <schema_pre.sql>
>
> <schema_post.sql>