Matthew Koppe
Matthew Koppe
PostsComments
PPrisma
Created by Matthew Koppe on 5/2/2025 in #help-and-questions
Can't install postgis extension with prisma postgres
I currently use an AWS RDS instance in production that has Postgis installed by default. For local development I have a docker instance running that has postgis installed too. I would like to migrate our databases over to Prisma Postgres for scaleability and pricing reasons, but when I tried to create a Prisma Postgres instance I couldn't enable the postgis extension and got this error: 
ERROR: extension "postgis" is not available
DETAIL: Could not open extension control file "/usr/local/share/postgresql/extension/postgis.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
ERROR: extension "postgis" is not available
DETAIL: Could not open extension control file "/usr/local/share/postgresql/extension/postgis.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
Is there any way to enable postgis on a hosted database instance? Or do I need to stick with RDS?
3 replies