GN 2.x to 3 migration

notes.MD

sdi.g.o Geonetwork migration issues

1. need to create a (temporary ?) hibernate_sequence in the public schema (or hibernate will complain)
2. settings table is definitely too hard to migrate using the migration system, truncating the table then inserting a default gn3-geor provided one. (tested by removing parentid / id by hand before with no luck)
3. permission denied for public.geometry_column => grant ALL on ...
4. Xmx set to 8196m
5. After all the previous changes, JAVA_OPTS looks like this:

JAVA_OPTS="-Djava.awt.headless=true -Xmx8192m -XX:+UseConcMarkSweepGC -Dgeorchestra.datadir=/etc/georchestra -Dgeonetwork.jeeves.configuration.overrides.file=/etc/georchestra/geonetwork/config/config-overrides-georchestra.xml"

6. Issue with the User table (not migrated by JPA ?): Profile is no more a varchar, but an integer (enum java side):

georchestra=# update geonetwork.users set profile = '0' where Profile = 'Administrator' ;
UPDATE 18
georchestra=# update geonetwork.users set profile = '3' where Profile = 'Editor' ;
UPDATE 2
georchestra=# update geonetwork.users set profile = '4' where Profile = 'RegisteredUser' ;
UPDATE 48
georchestra=# alter table geonetwork.users alter column profile TYPE integer USING (profile::integer);
ALTER TABLE

7. Following schemas do not exist anymore:

• fgdc-std
• iso19115
• iso19139.fra

Which represents 4 MDs from the non-harvested ones