add support to add shared_preload_libraries list in chart

cloudnative-pg / charts

CloudNativePG Helm Charts

Apache License 2.0

137 stars 62 forks source link

add support to add shared_preload_libraries list in chart #314

Closed kirankumar-grootan closed 1 week ago

kirankumar-grootan commented 3 weeks ago

add support to add shared library instead of hardcoded time timescaledb lib alone https://github.com/cloudnative-pg/charts/blob/main/charts/cluster/templates/cluster.yaml#L51

kirankumar-grootan commented 3 weeks ago

   shared_preload_libraries:
      {{- if eq .Values.type "timescaledb" }}
      - timescaledb
      {{- end }}
      {{- with .Values.cluster.postgresql.shared_preload_libraries }}
      {{ . | indent 6}}
      {{- end }}
    parameters: {{- toYaml .Values.cluster.postgresql.parameters | nindent 6 }}

we can change something like this

itay-grudev commented 3 weeks ago

Duplicate of #278, which I closed as I'm not sure I want to do this.

That being said, what is your use case? Change my mind.

kirankumar-grootan commented 1 week ago

Hi @itay-grudev

Thank you for looking into this ticket. I'm closing this issue. We previously deployed PostgreSQL using the default PostgreSQL image from Docker Hub, which required manual installation of the pg_stat_statements extension to retrieve query time. However, with the CloudNative PG image, this functionality is included by default, allowing us to obtain query time information without any additional steps.