i try to create postgis extension, but i get super user issues.
** CREATE EXTENSION postgis; **
ERROR: permission denied to create extension “postgis”
HINT: Must be superuser to create this extension.
Does it mean i will never be able to install or use this extension while on render’s instance??
Postgres databases with a version 12 or earlier had higher tier requirements ( https://render.com/docs/postgresql-extensions#postgresql-11-and-12:~:text=Not%20available%20on%20the%20Starter%20instance%20type ), but since 13 it is available even on Free databases.
I was able to create a Free tier database, and run CREATE EXTENSION postgis;
just now without issue.