Possibly useful H2 → PostgreSQL migration function

26 views
Skip to first unread message

Justin Clift

unread,
Apr 22, 2015, 4:54:45 AM4/22/15
to Repo and Gerrit Discussion
Hi all,

We've been doing some H2 → PostgreSQL migration stuff.

If anyone else needs to do the same thing, this might be
useful for you:

https://gist.github.com/justinclift/42dad0372e1aaa4f366c

It's a PostgreSQL implementation of H2's system_combine_clob()
function. If you load this into your PostgreSQL database
before loading the migrated data in, then it should correctly
restore the character large object (clob) data.

Hope that helps. :)

Regards and best wishes,

Justin Clift

--
GlusterFS - http://www.gluster.org

An open source, distributed file system scaling to several
petabytes, and handling thousands of clients.

My personal twitter: twitter.com/realjustinclift

Reply all
Reply to author
Forward
0 new messages