How can i use PosGIS extension in Dokploy's PostgreSQL?
Unanswered
Chow Chow posted this in #help-forum
Chow ChowOP
Hello. I am trying to work with the PostgreSQL database via Prisma and Dokploy, but the error extension "postgis" is not available occurs. Please tell me how to activate it via the control panel of Dokploy or anather way to do it. Error in terminal :
root@ultraacoustics:~# psql -h 77.110.106.142 -p 5432 -U root -d glowspot
Password for user root:
psql (15.12 (Ubuntu 15.12-1.pgdg24.04+1))
Type "help" for help.
glowspot=# CREATE EXTENSION postgis;
ERROR: extension "postgis" is not available
DETAIL: Could not open extension control file "/usr/share/postgresql/15/extension/postgis.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
glowspot=#
root@ultraacoustics:~# psql -h 77.110.106.142 -p 5432 -U root -d glowspot
Password for user root:
psql (15.12 (Ubuntu 15.12-1.pgdg24.04+1))
Type "help" for help.
glowspot=# CREATE EXTENSION postgis;
ERROR: extension "postgis" is not available
DETAIL: Could not open extension control file "/usr/share/postgresql/15/extension/postgis.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
glowspot=#