7 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
129
views
Should a single update query create multiple exclusive locks on the same table in postgres (CNPG)?
My system is running instances of postgres managed using CloudNativePG; there's a primary and a couple of replicas.
When I run a query like this update <table> set <boolean-column> = NOT &...
2
votes
2
answers
981
views
How does CloudnativePG encrypt data [closed]
# Example of PostgreSQL cluster
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
name: test-db-cluster
spec:
instances: 1
imageName: ghcr.io/cloudnative-pg/postgresql:16.1
backup:
...
0
votes
1
answer
2k
views
Why isn't it possible to disable archive mode in CloudNativePG PostgreSQL operator in kubernetes? [closed]
I'm configuring a CloudNativePG PostgreSQL operator in kubernetes. The data there is not very important and it is ok if we loose it. I want to disable WAL archiving because the archive files in the ...
1
vote
1
answer
615
views
How to activate bash-completion for cnpg's kubectl plugin when running on a local k3s node? [closed]
cnpg completion is designed to work when running like this:
. <( kubectl cnpg completion bash )
however, when running on a k3s node, the proper way to run kubectl is either:
k3s kubectl ...
or, ...
1
vote
2
answers
2k
views
How to run pgbench from a pod without having to type the password every time [Kubernetes] [CloudNativePG] [closed]
I am a user of Kubernetes, and I am using the CloudNativePG operator version 1.20.1 with PostgreSQL. Currently, I am conducting tests on clusters using the pgbench tool. However, when I execute the ...
0
votes
1
answer
722
views
Consistency guarantees, using quorum synchronous replication on postgresql, hosted with CloudNativePG [closed]
I want to integrate CNPG operator to my k8s cluster, but have several questions, I tried to find answers on the web, but couldn't, so decided to ask them here.
My team needs HA Postgres cluster with ...
0
votes
1
answer
2k
views
CloudNative PG - Invalid imageName with timescaledb docker image [closed]
I am trying to test CNPG with TimescaleDB, but applying the following CNPG Cluster configuration:
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
spec:
...
imageName: "timescaledb:2.10.2-pg15&...