timescale / timescaledb-docker-ha

Create Docker images containing TimescaleDB, Patroni to be used by developers and Kubernetes.
Apache License 2.0
155 stars 44 forks source link

How do I activate postgis on the image timescale/timescaledb-ha:pg15 ? #400

Closed hermesalvesbr closed 1 year ago

hermesalvesbr commented 1 year ago

I just ran the timescale/timescaledb-ha:pg15 image, however my software doesn't detect postgis. Do I need some environment variable to activate?

I tried POSTGIS_VERSIONS="3.3.3" , but that didn't work either.

Captura de tela de 2023-07-06 15-20-18

graveland commented 1 year ago

Are you sure the postgis extension was installed in your database? The binaries should be included, but you'd need to CREATE EXTENSION posgis; at the least. In psql, \dx should tell you.

hermesalvesbr commented 1 year ago

Hi there,

I resolved to make my own image: https://github.com/SoftagonSistemas/postgresql-15

Now work's for me.