[GeoNetwork-users] H2 to Postgres migration

Holmgrimur_Helgason · February 24, 2020, 1:52pm

Hello

What is the best way to migrate H2 GN data-base to Postgres?

Hóddi

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html

Francois_Prunayre · February 24, 2020, 2:43pm

Hi,

If you don't have a lot of users/groups, export as ZIP and import or
harvest and assign records to current catalog is probably the easiest way.
If not, then you have to try to dump SQL from H2 (not sure how easy it is)
and load to postgres.

Cheers.

Francois

Le lun. 24 févr. 2020 à 15:09, hoddih <hoddi@anonymised.com> a écrit :

Hello

What is the best way to migrate H2 GN data-base to Postgres?

Hóddi

--
Sent from:
http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Holmgrimur_Helgason · February 26, 2020, 9:39am

Hi

Is any "manual" for Dummies to this progress? Step by step.

I have 7.500.000 KB gn.h2.db file that I want to migrate to postgres!
It includes a few groups and users!

Hóddi

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html

Jo_Cook2 · February 27, 2020, 9:55am

Hi,

I thought I had some documentation on a gui for the h2 database, which
might provide you with tools for exporting the data but it looks as if
I didn't commit it to the manual. I'll do that now.

Jo

On Wed, Feb 26, 2020 at 9:39 AM hoddih <hoddi@anonymised.com> wrote:

Hi

Is any "manual" for Dummies to this progress? Step by step.

I have 7.500.000 KB gn.h2.db file that I want to migrate to postgres!
It includes a few groups and users!

Hóddi

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

--
Jo Cook
t:+44 7930 524 155/twitter:@archaeogeek
Please note that currently I do not work on Friday afternoons. For
urgent responses at that time, please visit
support.astuntechnology.com or phone our office on 01372 744009

--
--
*Sign up to our mailing list
<https://astuntechnology.com/company/#email-updates> for updates on news,
products, conferences, events and training*
*
*

Astun Technology Ltd,
Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK

t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/>
twitter:@astuntech <https://twitter.com/astuntech>

iShare - enterprise
geographic intelligence platform <https://astuntechnology.com/ishare/>

GeoServer, PostGIS and QGIS training
<https://astuntechnology.com/training-courses/>
Helpdesk and customer
portal
<https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal>

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

Jo_Cook2 · February 28, 2020, 9:08am

Hi Hóddi,

I committed my documentation about the Geonetwork H2 database at
https://geonetwork-opensource.org/manuals/trunk/en/customizing-application/misc.html#using-the-h2-database
but I'bve just had a look at the GUI tool dbeaver and it looks like it
should be able to handle your export/import requirements- see
https://github.com/dbeaver/dbeaver/wiki/Data-transfer. You would
probably want to start geonetwork up with a blank postgresql database
so that it sets up the tables correctly, then import your tables.

Hope that helps

Jo

On Thu, Feb 27, 2020 at 9:55 AM Jo Cook <jocook@anonymised.com> wrote:

Hi,

I thought I had some documentation on a gui for the h2 database, which
might provide you with tools for exporting the data but it looks as if
I didn't commit it to the manual. I'll do that now.

Jo

On Wed, Feb 26, 2020 at 9:39 AM hoddih <hoddi@anonymised.com> wrote:
>
> Hi
>
> Is any "manual" for Dummies to this progress? Step by step.
>
> I have 7.500.000 KB gn.h2.db file that I want to migrate to postgres!
> It includes a few groups and users!
>
>
> Hóddi
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>
>
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

--
Jo Cook
t:+44 7930 524 155/twitter:@archaeogeek
Please note that currently I do not work on Friday afternoons. For
urgent responses at that time, please visit
support.astuntechnology.com or phone our office on 01372 744009