The cli tool to migrate from H2 to PostgreSQL need to be upgraded to work in the GeoStore version based on Spring7.
Two main issues:
- H2 driver upgrade (needed for security) contains API breaking changes
- Outdated DB schema.
A more robust and future-proof approach would be to redesign the tool as a JDBC-based ETL process, directly reading data from H2 and writing it to PostgreSQL. This would eliminate the need for SQL parsing and regex-based transformations, improving correctness, maintainability, and compatibility with future database versions.
A slightly updated version is avaliable here: https://github.com/geosolutions-it/geostore/tree/h2-psql-cli
The cli tool to migrate from H2 to PostgreSQL need to be upgraded to work in the GeoStore version based on Spring7.
Two main issues:
A more robust and future-proof approach would be to redesign the tool as a JDBC-based ETL process, directly reading data from H2 and writing it to PostgreSQL. This would eliminate the need for SQL parsing and regex-based transformations, improving correctness, maintainability, and compatibility with future database versions.
A slightly updated version is avaliable here: https://github.com/geosolutions-it/geostore/tree/h2-psql-cli