P
Prisma•4w ago
Matthew Koppe

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?
2 Replies
Prisma AI Help
Prisma AI Help•4w ago
Salutations, traveler! I'm the Prisma AI Help Bot. You've reached a fork in the road: one path leads to the wisdom of the human sages (ETA: sometime today), and the other to my instantaneous insights. Which way shall we go?
Nurul
Nurul•4w ago
Hi! Currently we do not have support for postgres extensions, we do plan to support it very soon https://www.prisma.io/docs/postgres/more/known-limitations#postgres-extensions-are-not-supported Can you please fill out the form from linked docs? We will reach out to you as soon as support for extensions is added.
Known limitations about Prisma Postgres | Prisma Documentation
Learn about the known limitations of Prisma Postgres.

Did you find this page helpful?