How do i get to install postgis Extenseion on render's free postgres db instance

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.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.