Infoserve

Q: Unable to import wiki data - WARNING:  SET LOCAL can only be used in transaction blocks

I'm trying to use the wikiadmin tool to export all wikis from one server, and then import them onto another server, both on OS X El Capitan.

 

 

I can export the wikis fine from the first server

 

sudo wikiadmin export -all -path wikis

 

I then copy the exported files over to the second server and try to import them into the wiki

 

sudo wikiadmin import -all -path wikis/

 

 

The output is this message, about 31,000 times:

 

WARNING:  SET LOCAL can only be used in transaction blocks

 

 

There are no other errors, but nothing in the wiki on the second server changes.

 

 

Googling suggests it's related to PostgreSQL, but I haven't been able to find any suggestions on how to fix it. Any ideas on what to do next?

Mac mini, OS X Mavericks (10.9.1)

Posted on Jul 7, 2016 8:08 AM

Close

Q: Unable to import wiki data - WARNING:  SET LOCAL can only be used in transaction blocks

  • All replies
  • Helpful answers

  • by Linc Davis,

    Linc Davis Linc Davis Jul 7, 2016 9:32 AM in response to Infoserve
    Level 10 (207,926 points)
    Applications
    Jul 7, 2016 9:32 AM in response to Infoserve

    Apple has not documented a way to migrate Wiki data in the current version of OS X. I haven't tested this unofficial procedure, but there's no obvious reason why it wouldn't work.

  • by Infoserve,

    Infoserve Infoserve Jul 15, 2016 4:44 AM in response to Linc Davis
    Level 1 (4 points)
    Servers Enterprise
    Jul 15, 2016 4:44 AM in response to Linc Davis

    Hi Linc,

     

    Thanks for the reply. I followed the link you posted by that didn't work unfortunately. When looking through the database there's nothing with a create_time more recent than 2015, so it looks like the "wikiadmin import" didn't actually import anything.

     

    I don't know if there's anything else to try, as you mentioned there's not much documentation on migrating Apple Wikis.