# PostgreSQL **URL:** https://forums.percona.com/c/postgresql/25.md?page=2 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 3 --- ## [Percona postgresql operator frequent crashing due to leader election failure](https://forums.percona.com/t/percona-postgresql-operator-frequent-crashing-due-to-leader-election-failure/39892)
**Author:** [@vasanthnataraj](https://forums.percona.com/u/vasanthnataraj)\ **Replies:** 2\ **Last updated:** [December 16, 2025, 11:30am UTC](https://forums.percona.com/t/percona-postgresql-operator-frequent-crashing-due-to-leader-election-failure/39892 "2025-12-16T11:30:42Z")
Description: The Percona PostgreSQL operator is crashing due to leader election failure - it’s unable to communicate with the Kubernetes API server to maintain its leadership lease. if i try to change the operator lease… --- ## [Percona PostgreSQL Operator: Restore Fails with 'No Completed Backups Found' Error Despite Successful Backups in AWS S3](https://forums.percona.com/t/percona-postgresql-operator-restore-fails-with-no-completed-backups-found-error-despite-successful-backups-in-aws-s3/35605)
**Author:** [@ankitjodhani](https://forums.percona.com/u/ankitjodhani)\ **Replies:** 6\ **Last updated:** [December 8, 2025, 9:58am UTC](https://forums.percona.com/t/percona-postgresql-operator-restore-fails-with-no-completed-backups-found-error-despite-successful-backups-in-aws-s3/35605 "2025-12-08T09:58:44Z")
Percona PostgreSQL Operator: Restore Fails with ‘No Completed Backups Found’ Error Despite Successful Backups in AWS S3 :man\_raising\_hand: Hi Everyone, I’m reaching out after spending weeks troubleshooting this issue an… --- ## [Failed to create Pod: patroni-version-check](https://forums.percona.com/t/failed-to-create-pod-patroni-version-check/39671)
**Author:** [@Luke](https://forums.percona.com/u/Luke)\ **Replies:** 3\ **Last updated:** [November 29, 2025, 5:23pm UTC](https://forums.percona.com/t/failed-to-create-pod-patroni-version-check/39671 "2025-11-29T17:23:37Z")
Description: An error is logged during reconciliation when attempting to create the patroni-version-check pod if resources requests are set on the PerconaPGCluster resource. This seems to be caused by the PodLevelResour… --- ## [Does pg\_oidc\_validator work with Okta as well?](https://forums.percona.com/t/does-pg-oidc-validator-work-with-okta-as-well/39779)
**Author:** [@Praveen\_Gajulapalli](https://forums.percona.com/u/Praveen_Gajulapalli)\ **Replies:** 2\ **Last updated:** [November 25, 2025, 4:54pm UTC](https://forums.percona.com/t/does-pg-oidc-validator-work-with-okta-as-well/39779 "2025-11-25T16:54:51Z")
Does pg\_oidc\_validator work with Okta as well? --- ## [Error in percona logs - pg\_stat\_monitor: pg: out of memory](https://forums.percona.com/t/error-in-percona-logs-pg-stat-monitor-pg-out-of-memory/39083)
**Author:** [@ANDiv1976](https://forums.percona.com/u/ANDiv1976)\ **Replies:** 2\ **Last updated:** [November 21, 2025, 11:09am UTC](https://forums.percona.com/t/error-in-percona-logs-pg-stat-monitor-pg-out-of-memory/39083 "2025-11-21T11:09:38Z")
in the pmm-agent log, we get this error: “pmm-agent: time=“2025-08-12T04:08:25.731+00:00” level=error msg=“getNewBuckets failed: failed to query pg\_stat\_monitor: pq: out of memory” AgentID=daf6b1e1-8cec-4f84-a85b-e6d2f3d… --- ## [PGDB Restore and Backup Error](https://forums.percona.com/t/pgdb-restore-and-backup-error/39574)
**Author:** [@Kushal\_Sultania](https://forums.percona.com/u/Kushal_Sultania)\ **Replies:** 1\ **Last updated:** [November 12, 2025, 3:52am UTC](https://forums.percona.com/t/pgdb-restore-and-backup-error/39574 "2025-11-12T03:52:33Z")
I have a kubernetes cluster i am migrating from one to another. I want to restore previous cluster data to new one. When i try to create a normal restore cr and not use datasource , there is a initia backup taken , is t… --- ## [Bug in pg\_stat\_monitor version 2.1 . Database Hungs](https://forums.percona.com/t/bug-in-pg-stat-monitor-version-2-1-database-hungs/36906)
**Author:** [@harish.jaipu](https://forums.percona.com/u/harish.jaipu)\ **Replies:** 6\ **Last updated:** [November 8, 2025, 12:19am UTC](https://forums.percona.com/t/bug-in-pg-stat-monitor-version-2-1-database-hungs/36906 "2025-11-08T00:19:15Z")
Version psql (PostgreSQL) 16.6 - Percona Distribution. Database goes hung when the pg\_stat\_monitor query runs to fetch metrics. During this time no logs were gernerated in the error log and database was unresponsive and… --- ## [TDE in PostgreSQL in Windows](https://forums.percona.com/t/tde-in-postgresql-in-windows/39683)
**Author:** [@andre\_hass](https://forums.percona.com/u/andre_hass)\ **Replies:** 2\ **Last updated:** [November 5, 2025, 11:50pm UTC](https://forums.percona.com/t/tde-in-postgresql-in-windows/39683 "2025-11-05T23:50:43Z")
Hello Ist it possible to use pg\_tde on Windows host for existing prod environment? Br andre --- ## [Question about performance impact when change log\_statement from ddl to all](https://forums.percona.com/t/question-about-performance-impact-when-change-log-statement-from-ddl-to-all/39655)
**Author:** [@cuongtm02](https://forums.percona.com/u/cuongtm02)\ **Replies:** 2\ **Last updated:** [October 30, 2025, 3:04pm UTC](https://forums.percona.com/t/question-about-performance-impact-when-change-log-statement-from-ddl-to-all/39655 "2025-10-30T15:04:07Z")
Hi, We plan to audit all action of Percona postgresql v17 by change log\_statement from ddl to all, please advise: 1/ performance impact, is there any document for compare performance when change this parameter for busy… --- ## [Pg\_stat\_monitor 2.1 causes PG17.6 to segfault](https://forums.percona.com/t/pg-stat-monitor-2-1-causes-pg17-6-to-segfault/39523)
**Author:** [@pduchon](https://forums.percona.com/u/pduchon)\ **Replies:** 4\ **Last updated:** [October 24, 2025, 1:58pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-1-causes-pg17-6-to-segfault/39523 "2025-10-24T13:58:58Z")
(gdb) f #0 0x00007f2fd416ea7c in \_\_strlen\_evex () from /lib64/libc.so.6 (gdb) bt full #0 0x00007f2fd416ea7c in \_\_strlen\_evex () from /lib64/libc.so.6 No symbol table info available. #1 0x00000000007b8300 in CleanQuery… --- ## [Patroni and pgBackRest - full restore problem](https://forums.percona.com/t/patroni-and-pgbackrest-full-restore-problem/28077)
**Author:** [@pirolas](https://forums.percona.com/u/pirolas)\ **Replies:** 4\ **Last updated:** [October 23, 2025, 7:34am UTC](https://forums.percona.com/t/patroni-and-pgbackrest-full-restore-problem/28077 "2025-10-23T07:34:44Z")
Hello everyone, I’ve being trying hard to understand what’s going on with my configuration, maybe I’m the problem. For context I’ve a two node cluster, with patroni and postgresql in it, plus three node cluster of etcd… --- ## [Arm64 percona/pg-db](https://forums.percona.com/t/arm64-percona-pg-db/36413)
**Author:** [@dalu](https://forums.percona.com/u/dalu)\ **Replies:** 4\ **Last updated:** [October 17, 2025, 3:24pm UTC](https://forums.percona.com/t/arm64-percona-pg-db/36413 "2025-10-17T15:24:45Z")
Description: Trying to install percona/pg-db with helm tries to pull the amd64 images (I guess) and not the arm64 images, if they even exist. How can I use arm64 images? Steps to Reproduce: helm install pg-operator per… --- ## [TDE with PgSQL 17](https://forums.percona.com/t/tde-with-pgsql-17/39549)
**Author:** [@Ashish\_Mukherjee](https://forums.percona.com/u/Ashish_Mukherjee)\ **Replies:** 1\ **Last updated:** [October 14, 2025, 2:59pm UTC](https://forums.percona.com/t/tde-with-pgsql-17/39549 "2025-10-14T14:59:25Z")
I upgraded a TDE database to PgSQL 17 from PgSQL 12. My non-TDE pgsql 17 databases work fine. However, the TDE one I upgraded has the problem that query planner takes too long. Details below - DB size: 4T No. of table… --- ## [Postgres crashes and goes to the recovering mode after patching to 16.10](https://forums.percona.com/t/postgres-crashes-and-goes-to-the-recovering-mode-after-patching-to-16-10/39508)
**Author:** [@harish.jaipu](https://forums.percona.com/u/harish.jaipu)\ **Replies:** 1\ **Last updated:** [October 13, 2025, 1:02pm UTC](https://forums.percona.com/t/postgres-crashes-and-goes-to-the-recovering-mode-after-patching-to-16-10/39508 "2025-10-13T13:02:29Z")
Database reported core dump messages and kept going to recovery mode and was not starting up. postgres=# select \* from pg\_extension ; WARNING: terminating connection because of crash of another server process DETAIL:… --- ## [TDE and possibility of AES 256](https://forums.percona.com/t/tde-and-possibility-of-aes-256/39520)
**Author:** [@JustAnUser](https://forums.percona.com/u/JustAnUser)\ **Replies:** 1\ **Last updated:** [October 10, 2025, 4:17pm UTC](https://forums.percona.com/t/tde-and-possibility-of-aes-256/39520 "2025-10-10T16:17:59Z")
Good afternoon, I am currently evaluating PostgreSQL forks that offer Transparent Data Encryption (TDE) for a customer. Due to a requirement for post-quantum safety, support for AES-256 is essential. We would much pref… --- ## [PG\_TDE in a everest deployment](https://forums.percona.com/t/pg-tde-in-a-everest-deployment/39485)
**Author:** [@masterix](https://forums.percona.com/u/masterix)\ **Replies:** 6\ **Last updated:** [October 7, 2025, 7:42am UTC](https://forums.percona.com/t/pg-tde-in-a-everest-deployment/39485 "2025-10-07T07:42:48Z")
Hello, As it is explained in https://www.percona.com/blog/encrypt-postgresql-data-at-rest-on-kubernetes/ it is possible to configure pg\_tde using the kubernetes operator. Does anyone know if it is also possible to confi… --- ## [Percona PG-DB Helm chart does not have tolerations for all components](https://forums.percona.com/t/percona-pg-db-helm-chart-does-not-have-tolerations-for-all-components/38308)
**Author:** [@Raffaele\_Piccolo](https://forums.percona.com/u/Raffaele_Piccolo)\ **Replies:** 1\ **Last updated:** [September 28, 2025, 1:55pm UTC](https://forums.percona.com/t/percona-pg-db-helm-chart-does-not-have-tolerations-for-all-components/38308 "2025-09-28T13:55:05Z")
Description: Hi all, I am currently working with Percona Operator for PostgreSQL and Percona PostgreSQL DB. I am deploying both using helm charts from the official github repository (percona-helm-charts/charts at main ·… --- ## [Percona pg operator 2.7.0 problem with pmm3](https://forums.percona.com/t/percona-pg-operator-2-7-0-problem-with-pmm3/39396)
**Author:** [@Maveric](https://forums.percona.com/u/Maveric)\ **Replies:** 4\ **Last updated:** [September 28, 2025, 1:40pm UTC](https://forums.percona.com/t/percona-pg-operator-2-7-0-problem-with-pmm3/39396 "2025-09-28T13:40:54Z")
Hi, I upgraded my cluster to pg-operator 2.7.0 but still have a problem with pmm3. Pmm-client wants to get configuration from: /usr/local/percona/pmm2/config/pmm-agent.yaml but correct path should be: /usr/local/perc… --- ## [Can we use Percona toolkit commands for the postgres DB , As i want to audit my postgres DB by using percona toolkit?](https://forums.percona.com/t/can-we-use-percona-toolkit-commands-for-the-postgres-db-as-i-want-to-audit-my-postgres-db-by-using-percona-toolkit/39439)
**Author:** [@Yogesh123](https://forums.percona.com/u/Yogesh123)\ **Replies:** 1\ **Last updated:** [September 22, 2025, 4:19pm UTC](https://forums.percona.com/t/can-we-use-percona-toolkit-commands-for-the-postgres-db-as-i-want-to-audit-my-postgres-db-by-using-percona-toolkit/39439 "2025-09-22T16:19:14Z")
Can we use Percona toolkit commands for the postgres DB , As i want to audit my postgres DB by using percona toolkit? --- ## [Cron job issue for postgresql backup to s3 ](https://forums.percona.com/t/cron-job-issue-for-postgresql-backup-to-s3/32225)
**Author:** [@Surya\_Tyagi](https://forums.percona.com/u/Surya_Tyagi)\ **Replies:** 5\ **Last updated:** [September 22, 2025, 1:38pm UTC](https://forums.percona.com/t/cron-job-issue-for-postgresql-backup-to-s3/32225 "2025-09-22T13:38:51Z")
Descriptions We are using operator v2.4.0 , when i configured the backup to s3 or local (pvc) full and incremental . Using the following config in cr.yaml of the helm chart - spec: backups: pgbackrest: configurati… --- ## [How to specify vault namespace when create key provider?](https://forums.percona.com/t/how-to-specify-vault-namespace-when-create-key-provider/39333)
**Author:** [@Stanley\_Tam](https://forums.percona.com/u/Stanley_Tam)\ **Replies:** 2\ **Last updated:** [September 16, 2025, 3:19pm UTC](https://forums.percona.com/t/how-to-specify-vault-namespace-when-create-key-provider/39333 "2025-09-16T15:19:22Z")
We are using hvault with a dedicated namespace. How can we specify the namespace when creating TDE key provider and key? --- ## [Recommended postgresql.conf Settings for Production (8GB RAM, 8-core CPU, B2B Workload)](https://forums.percona.com/t/recommended-postgresql-conf-settings-for-production-8gb-ram-8-core-cpu-b2b-workload/39380)
**Author:** [@Zikou](https://forums.percona.com/u/Zikou)\ **Replies:** 1\ **Last updated:** [September 15, 2025, 8:22am UTC](https://forums.percona.com/t/recommended-postgresql-conf-settings-for-production-8gb-ram-8-core-cpu-b2b-workload/39380 "2025-09-15T08:22:24Z")
Hi everyone, We are in the process of setting up a new production database and would greatly appreciate some guidance on establishing a solid baseline for our postgresql.conf file. Our Environment PostgreSQL Version… --- ## [Does new release 17.5.3 fix the CVE-2025-8713 CVE-2025-8714 and CVE-2025-8715](https://forums.percona.com/t/does-new-release-17-5-3-fix-the-cve-2025-8713-cve-2025-8714-and-cve-2025-8715/39259)
**Author:** [@test\_test](https://forums.percona.com/u/test_test)\ **Replies:** 4\ **Last updated:** [September 11, 2025, 9:30am UTC](https://forums.percona.com/t/does-new-release-17-5-3-fix-the-cve-2025-8713-cve-2025-8714-and-cve-2025-8715/39259 "2025-09-11T09:30:56Z")
17.5.3 release in 1 Sep. Does it fix these CVE? --- ## [Access to source code](https://forums.percona.com/t/access-to-source-code/39327)
**Author:** [@did16](https://forums.percona.com/u/did16)\ **Replies:** 1\ **Last updated:** [September 10, 2025, 1:18pm UTC](https://forums.percona.com/t/access-to-source-code/39327 "2025-09-10T13:18:30Z")
Hi I would like to know how access to the source code of the Percona PostgreSQL Server distribution works. And what about access to the source code of the pg\_tde extension? Is it free or paid access? Thanks in advance … --- ## [Pgaudit: How to log command status](https://forums.percona.com/t/pgaudit-how-to-log-command-status/39323)
**Author:** [@fborden](https://forums.percona.com/u/fborden)\ **Replies:** 0\ **Last updated:** [September 10, 2025, 8:04am UTC](https://forums.percona.com/t/pgaudit-how-to-log-command-status/39323 "2025-09-10T08:04:29Z")
Hello all, looking at the pgaudit logs I can not see the event status of DDL or DML. All rows are “state: INPROGRESS” e.g. the following two rows in the audit trail: 2025-09-09 14:20:21.010 GMT,“postgres”,“hrprod”,84… --- ## [Backup stuck in starting starte](https://forums.percona.com/t/backup-stuck-in-starting-starte/39309)
**Author:** [@Kushal\_Sultania](https://forums.percona.com/u/Kushal_Sultania)\ **Replies:** 1\ **Last updated:** [September 9, 2025, 5:02pm UTC](https://forums.percona.com/t/backup-stuck-in-starting-starte/39309 "2025-09-09T17:02:13Z")
I have a percona pgdb cluster running in kubernetes cluster. Earlier I had all backups enabled (incr, diff, full), i updated and switched to only full backups. Now i see that any backup that starts (full backup) they are… --- ## [Percona backup restore from beta to dev env](https://forums.percona.com/t/percona-backup-restore-from-beta-to-dev-env/39265)
**Author:** [@Kushal\_Sultania](https://forums.percona.com/u/Kushal_Sultania)\ **Replies:** 4\ **Last updated:** [September 9, 2025, 9:34am UTC](https://forums.percona.com/t/percona-backup-restore-from-beta-to-dev-env/39265 "2025-09-09T09:34:03Z")
We are running postgres from percona (pgdb) in beta environment inside kubernetes cluster with backups configured to cloud s3 service. Trying to restore the backup in dev environment which is based on docker compose. Th… --- ## [ How to Rotate Internal Encryption Keys in pg\_tde?](https://forums.percona.com/t/how-to-rotate-internal-encryption-keys-in-pg-tde/39261)
**Author:** [@liebao](https://forums.percona.com/u/liebao)\ **Replies:** 1\ **Last updated:** [September 3, 2025, 6:52am UTC](https://forums.percona.com/t/how-to-rotate-internal-encryption-keys-in-pg-tde/39261 "2025-09-03T06:52:56Z")
Hi all, If the master key (or “principal key”) is compromised, an attacker could potentially derive the unencrypted internal keys from it. Currently, rotating the master key does not change the internal keys—it only re… --- ## [Pg\_tde – We invite you to contribute to developing a new extension for PostgreSQL](https://forums.percona.com/t/pg-tde-we-invite-you-to-contribute-to-developing-a-new-extension-for-postgresql/28014)
**Author:** [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)\ **Replies:** 2\ **Last updated:** [September 2, 2025, 7:32am UTC](https://forums.percona.com/t/pg-tde-we-invite-you-to-contribute-to-developing-a-new-extension-for-postgresql/28014 "2025-09-02T07:32:27Z")
Hi, We invite you to contribute to developing a new extension for PostgreSQL. The Percona team has developed an MVP (Minimum viable product) extension for Transparent Data Encryption (TDE) We will be grateful if you t… --- ## [Create PG Cluster via user interface not yaml](https://forums.percona.com/t/create-pg-cluster-via-user-interface-not-yaml/39212)
**Author:** [@kase007](https://forums.percona.com/u/kase007)\ **Replies:** 3\ **Last updated:** [September 1, 2025, 11:18pm UTC](https://forums.percona.com/t/create-pg-cluster-via-user-interface-not-yaml/39212 "2025-09-01T23:18:21Z")
Description: Could someone please help with creation of PGCluster via Operator in RedHat Openshift via user interface not the yaml itself? Is there any guide how to achive so? When I do so it never creates a POD. Also, … [Previous page](https://forums.percona.com/c/postgresql/25.md?page=1) [Next page](https://forums.percona.com/c/postgresql/25.md?page=3)