[Bug]: Directus installs require PostGis for map fields about coolify HOT 1 OPEN

I am also working on a project that requires postgis extension on the PostgreSQL db I am using. I'd love to get guides (if there are any) on enabling the extension.

I have tried running this command into the execute command:
psql -U ${POSTGRES_USER} -d ${POSTGRES_DB} -c "CREATE EXTENSION postgis;"

I have selected the db container and executed the command, then I 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.

I am now asking myself, how can I install the postgis extension before enabling it?

from coolify.