# PostgreSQL **URL:** https://forums.percona.com/c/postgresql/25.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [About the PostgreSQL category](https://forums.percona.com/t/about-the-postgresql-category/30)
**Author:** [@system](https://forums.percona.com/u/system)\ **Replies:** 1\ **Last updated:** [December 27, 2024, 9:35am UTC](https://forums.percona.com/t/about-the-postgresql-category/30 "2024-12-27T09:35:32Z")
For questions on PostgreSQL topics. --- ## [Loading keys over wire and evicting keys from cache in pg\_tde](https://forums.percona.com/t/loading-keys-over-wire-and-evicting-keys-from-cache-in-pg-tde/40633)
**Author:** [@WOXX](https://forums.percona.com/u/WOXX)\ **Replies:** 1\ **Last updated:** [October 19, 2026, 4:02am UTC](https://forums.percona.com/t/loading-keys-over-wire-and-evicting-keys-from-cache-in-pg-tde/40633 "2026-10-19T04:02:54Z")
Hi in pg\_tde, is it possible to set up eviction so keys are evicted from memory after a certain amount of time (or maybe inactivity or no connections) and required to be reloaded to use that db again? Or even not cache k… --- ## [PostgreSQL Percona TDE](https://forums.percona.com/t/postgresql-percona-tde/41340)
**Author:** [@kase007](https://forums.percona.com/u/kase007)\ **Replies:** 4\ **Last updated:** [October 15, 2026, 6:05am UTC](https://forums.percona.com/t/postgresql-percona-tde/41340 "2026-10-15T06:05:57Z")
Hello all, I have a question regarding TDE funcionality. Currently, I have a running cluster with TDE connected to hashicorp Vault. In case the vault became unreachable and PostgreSQL shutdown it wont startup. There is… --- ## [Pg\_tde\_archive\_decrypt/pg\_tde\_restore\_encrypt limitation in pgbackrest](https://forums.percona.com/t/pg-tde-archive-decrypt-pg-tde-restore-encrypt-limitation-in-pgbackrest/41250)
**Author:** [@grill](https://forums.percona.com/u/grill)\ **Replies:** 5\ **Last updated:** [October 15, 2026, 5:24am UTC](https://forums.percona.com/t/pg-tde-archive-decrypt-pg-tde-restore-encrypt-limitation-in-pgbackrest/41250 "2026-10-15T05:24:36Z")
Hey, wondering why you added the requirement to decrypt/encrypt the WAL if pgbackrest is used in the limitations documentation. I remember it wasn’t there before. We are currently using pgbackrest without encrypt/decr… --- ## [Prevent export keys from OpenBao](https://forums.percona.com/t/prevent-export-keys-from-openbao/41313)
**Author:** [@Alexander\_H](https://forums.percona.com/u/Alexander_H)\ **Replies:** 1\ **Last updated:** [October 5, 2026, 2:07pm UTC](https://forums.percona.com/t/prevent-export-keys-from-openbao/41313 "2026-10-05T14:07:41Z")
When using PG\_TDE with OpenBao, is it possible to prevent access to the key in OpenBao ? I am trying to make a case that the artefacts stored in OpenBao are securely managed and cannot be exported and used to access a TD… --- ## [Openshift - operator upgrade - OLM wants to upgrade 2.9.0 straight to 3.1.0](https://forums.percona.com/t/openshift-operator-upgrade-olm-wants-to-upgrade-2-9-0-straight-to-3-1-0/41289)
**Author:** [@eprevost](https://forums.percona.com/u/eprevost)\ **Replies:** 4\ **Last updated:** [September 29, 2026, 2:27am UTC](https://forums.percona.com/t/openshift-operator-upgrade-olm-wants-to-upgrade-2-9-0-straight-to-3-1-0/41289 "2026-09-29T02:27:11Z")
Hi, I have Percona Operator for Postgresql certified version 2.9.0-cw installed on an Openshift cluster. According to documentation, we have to go through all minor versions, so to upgrade from 2.9.0 to 3.1.0, 3.0.0 mu… --- ## [Installing pg\_stat\_monitor on AWS RDS databases](https://forums.percona.com/t/installing-pg-stat-monitor-on-aws-rds-databases/22071)
**Author:** [@Visha\_Shah](https://forums.percona.com/u/Visha_Shah)\ **Replies:** 2\ **Last updated:** [September 11, 2026, 2:21pm UTC](https://forums.percona.com/t/installing-pg-stat-monitor-on-aws-rds-databases/22071 "2026-09-11T14:21:11Z")
Hi, I am trying to install pg\_stat\_monitor on AWS RDS Databases but it seems that, its not allowed since AWS RDS is managed service by AWS however, there is parameter group option from which I can edit the configuration… --- ## [PG Operator 3.0.0+ compatibility with certified pgBackRest images](https://forums.percona.com/t/pg-operator-3-0-0-compatibility-with-certified-pgbackrest-images/41259)
**Author:** [@a.veselov.s](https://forums.percona.com/u/a.veselov.s)\ **Replies:** 2\ **Last updated:** [September 10, 2026, 6:33pm UTC](https://forums.percona.com/t/pg-operator-3-0-0-compatibility-with-certified-pgbackrest-images/41259 "2026-09-10T18:33:09Z")
Description: The percona/percona-pgbackrest:2.58.0-2 image is mentioned in the Percona certified images documentation for the operator v3.0.0. Unfortunately, using this image is blocked by a fatal mismatch between the p… --- ## [Performance Issue with Hash Calculation in PostgreSQL Triggers](https://forums.percona.com/t/performance-issue-with-hash-calculation-in-postgresql-triggers/41244)
**Author:** [@Dafur](https://forums.percona.com/u/Dafur)\ **Replies:** 3\ **Last updated:** [September 9, 2026, 4:01pm UTC](https://forums.percona.com/t/performance-issue-with-hash-calculation-in-postgresql-triggers/41244 "2026-09-09T16:01:43Z")
Hello, I am facing a performance issue while calculating the hash of inserted or deleted rows in an INSERT/UPDATE trigger in PostgreSQL. My data contains various field types, including integers, timestamps, strings, boo… --- ## [Timescaledb support](https://forums.percona.com/t/timescaledb-support/31490)
**Author:** [@martin.schack](https://forums.percona.com/u/martin.schack)\ **Replies:** 4\ **Last updated:** [September 9, 2026, 3:38pm UTC](https://forums.percona.com/t/timescaledb-support/31490 "2026-09-09T15:38:47Z")
Description: I’ve been asked by different colleagues if I can provide the “timescaledb” extension for them. Seems like this is a very popular extension. Do you have any plans to integrate this for upcoming releases? D… --- ## [Percona Patroni EOL Support with Ubuntu Pro for 22.04](https://forums.percona.com/t/percona-patroni-eol-support-with-ubuntu-pro-for-22-04/40892)
**Author:** [@zubin.parihar.bcgeu](https://forums.percona.com/u/zubin.parihar.bcgeu)\ **Replies:** 4\ **Last updated:** [August 17, 2026, 6:32am UTC](https://forums.percona.com/t/percona-patroni-eol-support-with-ubuntu-pro-for-22-04/40892 "2026-08-17T06:32:14Z")
Hey folks, Ubuntu 22.04 LTS has an EOL on April 2027 However, if we purchase Ubuntu Pro, that gives us 10 - 15 Years of support via Canonical. However, if we install Percona Apt Repos for Patroni+PostgreSQL 17, is the… --- ## [Open-Source Kubernetes Version Support](https://forums.percona.com/t/open-source-kubernetes-version-support/41069)
**Author:** [@Srinivas](https://forums.percona.com/u/Srinivas)\ **Replies:** 3\ **Last updated:** [July 16, 2026, 12:37pm UTC](https://forums.percona.com/t/open-source-kubernetes-version-support/41069 "2026-07-16T12:37:11Z")
Description: What is the Open-Source Kubernetes version supported for Percona Operator 2.8.2 version Steps to Reproduce: This is information request to know the supported Kubernetes version for Percona Postgres operator… --- ## [Adding KMIP Global Key Providers for Standby KMIP Keystores](https://forums.percona.com/t/adding-kmip-global-key-providers-for-standby-kmip-keystores/41020)
**Author:** [@NatashaLR](https://forums.percona.com/u/NatashaLR)\ **Replies:** 5\ **Last updated:** [July 9, 2026, 11:20am UTC](https://forums.percona.com/t/adding-kmip-global-key-providers-for-standby-kmip-keystores/41020 "2026-07-09T11:20:08Z")
Hi All. Two questions regarding Percona Postgresql V18 pg\_tde:- Can you add more X1 KMIP key provider IP for KMIP redundancy/ standby server tests ? Primary KMIP Keystore IP SELECT pg\_tde\_add\_global\_key\_provider\_kmi… --- ## [PPG RPMs for RHEL10 missing](https://forums.percona.com/t/ppg-rpms-for-rhel10-missing/38879)
**Author:** [@ziegenberg](https://forums.percona.com/u/ziegenberg)\ **Replies:** 22\ **Last updated:** [June 23, 2026, 10:06pm UTC](https://forums.percona.com/t/ppg-rpms-for-rhel10-missing/38879 "2026-06-23T22:06:20Z")
When trying to install PostgreSQL (any version) on a RHEL 10 machine I get the following error message from percona-release: $ percona-release setup -y ppg-15 Specified repository is not supported for current operating… --- ## [Patroni replication behaves the same regardless of the value set for synchronous\_mode\_strict](https://forums.percona.com/t/patroni-replication-behaves-the-same-regardless-of-the-value-set-for-synchronous-mode-strict/40856)
**Author:** [@Srinivas](https://forums.percona.com/u/Srinivas)\ **Replies:** 1\ **Last updated:** [June 23, 2026, 5:38am UTC](https://forums.percona.com/t/patroni-replication-behaves-the-same-regardless-of-the-value-set-for-synchronous-mode-strict/40856 "2026-06-23T05:38:41Z")
Percona Operator Version: 2.8.2 Postgres Version: 16 We have defined the below parameters related to Patroni replication. It is expected that writes will continue when the parameter synchronous\_mode\_strict set to false… --- ## [Three questions about Percona Postgresql](https://forums.percona.com/t/three-questions-about-percona-postgresql/37766)
**Author:** [@kevin310007](https://forums.percona.com/u/kevin310007)\ **Replies:** 7\ **Last updated:** [June 22, 2026, 5:32pm UTC](https://forums.percona.com/t/three-questions-about-percona-postgresql/37766 "2026-06-22T17:32:45Z")
Q1: I already install Community PG16.8 at Oracle linux 9.5 and with some tables. I want to use tde\_heap function to encrypt my tables. here are my setup below: Install Percona Postgresql 17.4.1 Use pg\_dump to export my… --- ## [Is Master Master Replication possible](https://forums.percona.com/t/is-master-master-replication-possible/40926)
**Author:** [@deepak.kv](https://forums.percona.com/u/deepak.kv)\ **Replies:** 1\ **Last updated:** [June 18, 2026, 6:53am UTC](https://forums.percona.com/t/is-master-master-replication-possible/40926 "2026-06-18T06:53:49Z")
I have 7 nodes PostgreSQL, Etcd, Patroni cluster setup. In which, 3 nodes are on-premises and 4 nodes are on cloud. I want to make 1 master in on-premises setup and 1 master in cloud setup. I also want Master-Master Repl… --- ## [Llvmjit.so fails to load in percona-postgresql-17 container](https://forums.percona.com/t/llvmjit-so-fails-to-load-in-percona-postgresql-17-container/40690)
**Author:** [@chemp](https://forums.percona.com/u/chemp)\ **Replies:** 6\ **Last updated:** [June 8, 2026, 11:50am UTC](https://forums.percona.com/t/llvmjit-so-fails-to-load-in-percona-postgresql-17-container/40690 "2026-06-08T11:50:37Z")
Hello, I have encountered this issue while working with this image: perconalab/percona-distribution-postgresql-with-postgis:17.9. When PostgreSQL’s JIT compiler activates, loading /usr/pgsql-17/lib/llvmjit.so fails with… --- ## [Postgres backup stuck in starting problem](https://forums.percona.com/t/postgres-backup-stuck-in-starting-problem/40815)
**Author:** [@ahmad\_taknet](https://forums.percona.com/u/ahmad_taknet)\ **Replies:** 4\ **Last updated:** [June 1, 2026, 10:53am UTC](https://forums.percona.com/t/postgres-backup-stuck-in-starting-problem/40815 "2026-06-01T10:53:11Z")
What is the problem and how can I solve it? 89s Warning UnableToCreateStanzas postgrescluster/postgresql-c2a command terminated with exit code 1: postgres operator error:… --- ## [Physical replication slot created through patroni configuration has retained the wal beyond default max\_wal\_size = 1 GB](https://forums.percona.com/t/physical-replication-slot-created-through-patroni-configuration-has-retained-the-wal-beyond-default-max-wal-size-1-gb/40735)
**Author:** [@deepak.kv](https://forums.percona.com/u/deepak.kv)\ **Replies:** 4\ **Last updated:** [May 25, 2026, 7:46am UTC](https://forums.percona.com/t/physical-replication-slot-created-through-patroni-configuration-has-retained-the-wal-beyond-default-max-wal-size-1-gb/40735 "2026-05-25T07:46:40Z")
We have created 3 node postgresql, patroni, etcd High Availability and Failover cluster. For this cluster, patroni configuration is as below - namespace: ${NAMESPACE} scope: ${SCOPE} name: ${NODE\_NAME} restapi: list… --- ## [Compiling pg\_tde into PostgreSQL 18.3 from source](https://forums.percona.com/t/compiling-pg-tde-into-postgresql-18-3-from-source/40626)
**Author:** [@gurucubano](https://forums.percona.com/u/gurucubano)\ **Replies:** 1\ **Last updated:** [May 24, 2026, 1:31pm UTC](https://forums.percona.com/t/compiling-pg-tde-into-postgresql-18-3-from-source/40626 "2026-05-24T13:31:19Z")
Hello, We’re a software producer in the Library Management Market and compile PostgreSQL on SuSE Linux Enterprise from source. In the actual used version (16.5) we compiled pg\_tde by git cloning it to postgresql-16.5/co… --- ## [Update etcd to 3.5.28/3.5.29 for Percona Distribution for PostgreSQL (CVE-2026-XXXX)](https://forums.percona.com/t/update-etcd-to-3-5-28-3-5-29-for-percona-distribution-for-postgresql-cve-2026-xxxx/40610)
**Author:** [@Sourcream\_suicide](https://forums.percona.com/u/Sourcream_suicide)\ **Replies:** 3\ **Last updated:** [May 24, 2026, 1:05pm UTC](https://forums.percona.com/t/update-etcd-to-3-5-28-3-5-29-for-percona-distribution-for-postgresql-cve-2026-xxxx/40610 "2026-05-24T13:05:44Z")
Hi Percona Team, I’m using Percona Distribution for PostgreSQL 18.3. The current etcd version in the repository is 1:3.5.26-1.noble. Recently, a critical vulnerability was announced regarding etcd Auth bypass (CVE-2026… --- ## [High memory usage of PostgreSQL leader pod](https://forums.percona.com/t/high-memory-usage-of-postgresql-leader-pod/40727)
**Author:** [@an-toine](https://forums.percona.com/u/an-toine)\ **Replies:** 11\ **Last updated:** [May 21, 2026, 7:16am UTC](https://forums.percona.com/t/high-memory-usage-of-postgresql-leader-pod/40727 "2026-05-21T07:16:38Z")
Description: Hello ! We are using the Percona PostgreSQL operator to instanciate databases in a Kubernetes cluster. Lately, we have received alerts about the leader pod being evicted because of memory pressure on a nod… --- ## [The former primary pod did not start as a replica during few scenarios](https://forums.percona.com/t/the-former-primary-pod-did-not-start-as-a-replica-during-few-scenarios/40819)
**Author:** [@Srinivas](https://forums.percona.com/u/Srinivas)\ **Replies:** 0\ **Last updated:** [May 20, 2026, 7:37am UTC](https://forums.percona.com/t/the-former-primary-pod-did-not-start-as-a-replica-during-few-scenarios/40819 "2026-05-20T07:37:24Z")
The former primary pod did not start as a replica during few scenarios either during network isolation or when its worker node was unavailable. Below are performed to start former primary pod as replica and pod stuck at… --- ## [Percona Postgres: Primary promotion happened during parameter change and behavior during pod delete forcefully](https://forums.percona.com/t/percona-postgres-primary-promotion-happened-during-parameter-change-and-behavior-during-pod-delete-forcefully/40811)
**Author:** [@Srinivas](https://forums.percona.com/u/Srinivas)\ **Replies:** 0\ **Last updated:** [May 18, 2026, 11:07am UTC](https://forums.percona.com/t/percona-postgres-primary-promotion-happened-during-parameter-change-and-behavior-during-pod-delete-forcefully/40811 "2026-05-18T11:07:27Z")
Please clarify understanding to the below questions. We changed the parameter “patroni.leaderLeaseDurationSeconds,” which triggered a pod restart one at a time for both the primary and replica pods. We also observed a… --- ## [Patronictl TL mean?](https://forums.percona.com/t/patronictl-tl-mean/27989)
**Author:** [@parttime](https://forums.percona.com/u/parttime)\ **Replies:** 9\ **Last updated:** [May 9, 2026, 9:32pm UTC](https://forums.percona.com/t/patronictl-tl-mean/27989 "2026-05-09T21:32:42Z")
hi all, when ı list patronictl list get the TL. what does it mean TL ? how can we do 0 ? \[server01 ~\]$ patronictl -c /etc/patroni/patroni.yml list Cluster: name ---------------------------±—±----------+ | Member … --- ## [How to properly upgrade pg\_tde from 2.1.1 to 2.1.2 on Patroni cluster with pgbackrest and WAL encryption?](https://forums.percona.com/t/how-to-properly-upgrade-pg-tde-from-2-1-1-to-2-1-2-on-patroni-cluster-with-pgbackrest-and-wal-encryption/40484)
**Author:** [@Sourcream\_suicide](https://forums.percona.com/u/Sourcream_suicide)\ **Replies:** 1\ **Last updated:** [May 7, 2026, 5:04pm UTC](https://forums.percona.com/t/how-to-properly-upgrade-pg-tde-from-2-1-1-to-2-1-2-on-patroni-cluster-with-pgbackrest-and-wal-encryption/40484 "2026-05-07T17:04:30Z")
Environment: - PostgreSQL 18 - pg\_tde 2.1.1 - Patroni HA cluster (2 nodes) - pgbackrest for backups (repository on nodeA, backups from leader) - WAL encryption enabled (pg\_tde.wal\_encrypt = on) - File-based key pro… --- ## [What is the future of backup with pgBackRest](https://forums.percona.com/t/what-is-the-future-of-backup-with-pgbackrest/40743)
**Author:** [@Baptiste\_Mille-Mathi](https://forums.percona.com/u/Baptiste_Mille-Mathi)\ **Replies:** 1\ **Last updated:** [May 5, 2026, 6:52am UTC](https://forums.percona.com/t/what-is-the-future-of-backup-with-pgbackrest/40743 "2026-05-05T06:52:57Z")
Hi PbBackRest developer announced last week he would stop developing it. I’m sure in the coming months it won’t be an issue, but what in the mid-term future? Do guys have some ideas ? --- ## [Integration with cert-manager - custom issuer](https://forums.percona.com/t/integration-with-cert-manager-custom-issuer/40739)
**Author:** [@spronin](https://forums.percona.com/u/spronin)\ **Replies:** 2\ **Last updated:** [May 3, 2026, 5:25pm UTC](https://forums.percona.com/t/integration-with-cert-manager-custom-issuer/40739 "2026-05-03T17:25:46Z")
Description: I want to use my own Issuer and cert-manager with PostgreSQL Operator. Right now when I have cert-manager deployed, Operator creates the Issuer , Certificate resources and Secrets for me. All self-signed. It… --- ## [PgbackRest is EOL](https://forums.percona.com/t/pgbackrest-is-eol/40720)
**Author:** [@Leo\_Ma](https://forums.percona.com/u/Leo_Ma)\ **Replies:** 2\ **Last updated:** [April 29, 2026, 2:39am UTC](https://forums.percona.com/t/pgbackrest-is-eol/40720 "2026-04-29T02:39:04Z")
As a famous backup product What is our roadmap and plan [Next page](https://forums.percona.com/c/postgresql/25.md?page=1)