Storage - Database beta - PostGIS extensions

#1

I just want to share some feedback about the Database beta.

Could be great if we can use the full postgis library for PostgreSQL :slight_smile:

I tried it, but just some of the needed extensions can be activaded, see the pasted log:

rdb=> CREATE EXTENSION postgis;
CREATE EXTENSION
rdb=> CREATE EXTENSION postgis_topology;
ERROR:  permission denied to create extension "postgis_topology"
HINT:  Must be superuser to create this extension.
rdb=> CREATE EXTENSION postgis_sfcgal;
ERROR:  permission denied to create extension "postgis_sfcgal"
HINT:  Must be superuser to create this extension.
rdb=> CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION
rdb=> CREATE EXTENSION address_standardizer;
ERROR:  permission denied to create extension "address_standardizer"
HINT:  Must be superuser to create this extension.
rdb=> CREATE EXTENSION address_standardizer_data_us;
ERROR:  permission denied to create extension "address_standardizer_data_us"
HINT:  Must be superuser to create this extension.
rdb=> CREATE EXTENSION postgis_tiger_geocoder;
ERROR:  permission denied to create extension "postgis_tiger_geocoder"
HINT:  Must be superuser to create this extension.

Full installation guide can be reviewed at https://postgis.net/install/

Cheers!

#2

Hello @xtorello,

Currently, these extensions are not available yet, but your suggestion has been forwarded to the product team, and we will keep you updated once they are available.

Best regards,
Benedikt

#3

Great! :slight_smile:

KR,