postgres-operator

postgres-operator copied to clipboard

postgres_exporter: set auto-discover-databases=true

2

I found that the default postgres_exporter configuration only scrapes the "postgres" database (_auto-discover-databases=false_). Setting _auto-discover-databases=true_ would scrape metrics for _**all**_ databases per postgres_exporter documentation. I could not find a possiblity...

mzwettler2

Missing libraries in upgrader image

5

Missing libraries in the upgrader image ## Overview Upon attempting to upgrade a cluster from postgres version 13 to version 14 wherein the cluster there is a database with the...

CPinhoK

Automatically increase size of PVCs

2

## Overview Crunchy Data recommends leaving a proportional amount of space free on disk. However it's currently a manual process to monitor disk consumption and modify the `PostgresCluster` spec to...

gricey432

Primary & Replicas continuously restarting

5

Please ensure you do the following when reporting a bug: - [ ] Provide a concise description of what the bug is. Primary & Replicas continuously restarting in postgresql operator...

vaigau6g

How to set PATRONI_LOG_LEVEL environment variable with PGO 5.1.2?

17

I want to set environment variable PATRONI_LOG_LEVEL on all PostgreSQL pods created by the Crunchydata PGO 5.1.2 on Kubernetes. If I edit the pod directly and add the following it...

johnswarbrick

Allow defining metadata on repoHost that does not propagate to cronjobs, etc

6

# Overview & why I'm using Velero to create backups of the pgbackrest volume created by PGO. This is done by setting the annotation on the pod which uses this...

Kajot-dev

pgo 4.7 pg 11: could not save history to file "/var/lib/pgsql/.psql_history": No such file or directory

3

I have installed pgo 4.7 and created a cluster as such: ``` $ pgo -n pgo-4-7-0 show cluster pgo-osb-management cluster : pgo-osb-management (crunchy-postgres-ha:centos8-11.12-4.7.0) pod : pgo-osb-management-59478c7785-6pxd6 (Running) on k3d-abn-mirror-agent-1 (2/2)...

jose-joye

Manual database backup error and duplicated backup

11

## Overview I am testing Crunchy Postgres database backup on Openshift, and I found there are 2 results I do not understand. (1) Multiple backup Pods were started and some...

Eric-zch

wal retention

8

Hello. I use postgres operator v5. It looks like WAL logs of the database growing rapidly. Can we apply retention to WAL logs? Like storing WAL logs from 10 days...

bilemedimkq

Cluster read-only

1

To get the context: I have PGO v5.0.3 installed on a GCP kubernetes cluster with 3 nodes (1 primary & 2 replicas). Today we got an issue where one of...

Martin-Hogge