How can i use PostGIS extension in Dokploy PostgreSQL
Hello. I am trying to work with the PostgreSQL database via Prisma, but the error extension "postgis" is not available occurs. Please tell me how to activate it via the control panel of Dokploy. 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=#
