HA setup with pg_prometheus extenstion about helm-charts HOT 3 CLOSED

No, that Docker image does not contain Patroni.

However, the Docker image that is referred to in this repository does have pg_prometheus installed, so by setting the following in your values.yaml you should have pg_prometheus preloaded:

myvalues.yaml

patroni:
  bootstrap:
    dcs:
      postgresql:
        parameters:
          shared_preload_libraries: timescaledb,pg_prometheus,pg_stat_statements

Afterwards, you can install the extension in any database:

$ kubectl exec -ti pod/deployment-timescaledb-0 -- psql
psql (11.6 (Debian 11.6-1.pgdg100+1))
Type "help" for help.

postgres=# CREATE EXTENSION pg_prometheus;
CREATE EXTENSION
postgres=# \dx pg_prometheus
                     List of installed extensions
     Name      | Version | Schema |            Description            
---------------+---------+--------+-----------------------------------
 pg_prometheus | 0.2.2   | public | Prometheus metrics for PostgreSQL
(1 row)

postgres=# 

from helm-charts.

Thanks, I followed the instructions and it works. Another question I have is, there are two repos on docker hub, timescaledev and timescale, are they the same?

from helm-charts.

timescaledev and timescale, are they the same?

No, they are different; as the Docker image of these Helm Charts is becoming quite stable, it may be time to switch that Docker image to timescale instead of timescaledev.

from helm-charts.