Directus Map Interface requires the PostGIS extension on postgres

[markjames]

Hi Girish,
Great work bundling up Directus 9, however, I've run into a problem.

While looking to implement the built in map interface, it errored because PostGIS isn't installed.

The logs files during startup also highlights this issue -

PostGIS isn't installed. Geometry type support will be limited.

A quick google suggests this is an extension that can be added to Postgres.

https://postgis.net/install/

Is this something I can add into the postgres bundled with Cloudron?

Thanks!

[girish]

@markjames I have enabled the postgis extensions in the next release (7.1). Should be out next week.

[markjames]

Great, thanks @girish!

[msbt]

@girish I just installed a fresh Directus and it still shows what @markjames mentioned earlier. Are the changes live yet?

[luckow]

@msbt Is your Cloudron instance on version 7.1.x?

[msbt]

@luckow yes, v7.1.2 (Ubuntu 20.04.4 LTS)

[luckow]

@msbt hmm.

[girish]

@msbt yes. So, the expectation was that the app will do "CREATE EXTENSION postgis" if it needs it but looks like directus doesn't do this automatically. I will fix the app package but in the meantime, Web Terminal -> Postgresql -> CREATE EXTENSION postgis . Then restart directus.

[msbt]

@girish nice, thanks!