Hi Xin,

the main problem for using PostgreSQL and XWiki is the correct mapping of the data types of MySQL to Postgres. 
This has been addressed in my posting on Feb.07 titled:
   XWiki 0.9 to 1.0Beta Postgres Database Upgrade using DATA only
I couldn't find it in the mail archive (don't know why) and therefore will repost it in a few minutes.

Regards,
Rudolf van der Leeden


On Mar 5, 2007, at 10:36 AM, Vincent Massol wrote:


On Mar 5, 2007, at 10:30 AM, xin wu wrote:

Hi,

 Thanks to all of you. The errors are due to limitation of the xml doc table
(I just do what Paul said: change the limitation of xwd_class_xml in
xml doc table from 20000 to 200000, I also change xwd_archive from
200000 to 2000000). Then the installation seemed OK except that
preference page is locked by XWikiGuest(You can just edit it by
force). I think it will be better to mention the size limitation in
the guide.

Yes that's a good idea. Can you do it?

Thanks
-Vincent

Many thanks again.

On 3/5/07, Sergiu Dumitriu <sergiu.dumitriu@gmail.com> wrote:

On 3/5/07, Vincent Massol <vincent@massol.net> wrote:
>
>
>
>
> On Mar 5, 2007, at 8:46 AM, Sergiu Dumitriu wrote:
>
> I don't think it's related to XWIKI-530, since the import works for most
pages, except the specified 2.
>
> Indeed, importing the XWikiPreferences page causes an error. The page is
deleted, but not imported back.
>
>
> Sergiu, is this a regression? I've never had this problem with the
XWikiPreferences page. Do we have a jira for it? Is it fixed in Beta 5?

Here's the error I got (yesterday, so b5 doesn't fix it):

13:27:30,130 [TP-Processor6] WARN  util.JDBCExceptionReporter      - SQL
Error: 1062, SQLState: 23000
13:27:30,132 [TP-Processor6] ERROR util.JDBCExceptionReporter      -
Duplicate entry '-944455444-tags' for key 1
13:27:30,133 [TP-Processor6] ERROR .AbstractFlushingEventListener  - Could
not synchronize database state with session
org.hibernate.exception.ConstraintViolationException :
could not insert: [com.xpn.xwiki.objects.IntegerProperty]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)


So it's a duplicate key issue.


 --

--
You receive this message as a subscriber of the xwiki-users@objectweb.org
mailing list.
To unsubscribe:
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws




-- 


                                   Best regards,
                                         Xin


--
You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list.
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--
You receive this message as a subscriber of the xwiki-users@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