Hexagon Geospatial
MENU

M.App Enterprise

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 65
Registered: ‎11-02-2015

Update M.App Enterprise to 2018 and PostgrSQL/PostGIS

Hi guys,

 

after spending some time (together with Stefan) to find the reason for problems during/after the upgrade I though it is a good idea toshare my experience with you:

 

During the upgrade existing tenant databases will be upgraded to a new database scheme. The tenants DBs used in 2016 or earlier have been simple DB without the PostGIS extension enabled. With 2018 all tenant DBs must be spatial enabled since the mobile component is storing boundary geometries in the DB. So during the update the PostGIS extension will be enabled for all exisiting tenant DBs.

 

Unfortunately, this will only work if you use a DB administrator (e.g. postgres) in the tenant DB connection string. I have been using a normal user (with fully rights on the tenant DB). Even if this is the owner of the DB he has no rights to enable extensions.

 

So, I have changed the connection string replacing the "normal user" with "postgres". Then I re-launched the installer with the modify option. After the reconfiguration the DB-schema of all existing tenants has been updated successfully. You should find 69 instead of 55 tables in the tenant DB.

 

Cheers

Fritz

Geography is what geographers do...
Regular Contributor
Posts: 200
Registered: ‎03-10-2016

Re: Update M.App Enterprise to 2018 and PostgrSQL/PostGIS

Thanks for sharing Fritz!

GAUSS Ingenieurtechnik GmbH | Germany
Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Development Ticket through our Development Ticket Portal.