Prisma•8mo ago

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?

5 Replies

Prisma AI Help•8mo 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•8mo 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.

Ankur Datta•4mo ago

Hey @Matthew Koppe 👋🏾 , we now have pgvector extension for Prisma Postgres 🥳 . You'll find more details in the launch article. Let me know if you have any questions!

Prisma

ORM 6.13.0, CI/CD Workflows & pgvector for Prisma Postgres

Prisma ORM v6.13.0 introduces Prisma Config & multi-schema support in GA, pgvector for Prisma Postgres, a new Management API for CI/CD, SQL view enhancements, and a redesigned Prisma Console UI.

Eric•3mo ago

@Ankur Datta this thread is for postgis, not pgvector. I'm also interested in postgis and can't use Prisma Postgres until that's available. I've filled out the form but interested to know if there's any timeline? @Ankur Datta any updates? I noticed a bunch of new extensions were quietly added to the supported list but sadly not postgis 😢 Our company really wants to move to Prisma Postgres, other than this it looks perfect for our needs and we need to move to a new solution very soon.

Eric•3w ago

@Ankur Datta @Nurul (Prisma) Any updates on postgis? It's been coming "soon" for many months now.

Gaming

Programming

Can't install postgis extension with prisma postgres

Did you find this page helpful?