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.

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?

Can't install postgis extension with prisma postgres

Similar Threads

Similar Threads

Similar Threads