# \#postgresql **URL:** https://forums.percona.com/tag/postgresql/33.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [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… --- ## [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… --- ## [Repository ppg-17.6 returns 404](https://forums.percona.com/t/repository-ppg-17-6-returns-404/40000)
**Author:** [@anju](https://forums.percona.com/u/anju)\ **Replies:** 2\ **Last updated:** [March 12, 2026, 6:30am UTC](https://forums.percona.com/t/repository-ppg-17-6-returns-404/40000 "2026-03-12T06:30:16Z")
Description The ppg-17.6-release-x86\_64 repository configured in the percona-postgresql-operator:2.8.0-ppg17.6-postgres-gis3.3.8 container image returns a 404 error, causing microdnf update to fail during downstream imag… --- ## [Can't start backup. Previous backup is still in progress](https://forums.percona.com/t/cant-start-backup-previous-backup-is-still-in-progress/37913)
**Author:** [@pstekunov](https://forums.percona.com/u/pstekunov)\ **Replies:** 6\ **Last updated:** [February 26, 2026, 6:14am UTC](https://forums.percona.com/t/cant-start-backup-previous-backup-is-still-in-progress/37913 "2026-02-26T06:14:42Z")
Description: Backup jobs not created anymore Steps to Reproduce: Version: 2.6.0 Logs: 2025-05-12T12:53:44.628Z INFO Can’t start backup. Previous backup is still in progress {“controller”: “perconapgbackup”, “controller… --- ## [Seeking best practices and real world experiences around managing, tuning, and operating PostgreSQL and MongoDB databases in production environments at scale](https://forums.percona.com/t/seeking-best-practices-and-real-world-experiences-around-managing-tuning-and-operating-postgresql-and-mongodb-databases-in-production-environments-at-scale/40180)
**Author:** [@Sachin\_R](https://forums.percona.com/u/Sachin_R)\ **Replies:** 1\ **Last updated:** [February 17, 2026, 3:00pm UTC](https://forums.percona.com/t/seeking-best-practices-and-real-world-experiences-around-managing-tuning-and-operating-postgresql-and-mongodb-databases-in-production-environments-at-scale/40180 "2026-02-17T15:00:25Z")
Hi everyone, I’m looking to start a discussion around real world database administration challenges for PostgreSQL and MongoDB in production environments. Specifically, I’m interested in hearing from DBAs and platform … --- ## [Pmm3 can connect to database, throws pg\_hba error on pt-pg-summary](https://forums.percona.com/t/pmm3-can-connect-to-database-throws-pg-hba-error-on-pt-pg-summary/37908)
**Author:** [@yngmntr](https://forums.percona.com/u/yngmntr)\ **Replies:** 3\ **Last updated:** [February 3, 2026, 11:00am UTC](https://forums.percona.com/t/pmm3-can-connect-to-database-throws-pg-hba-error-on-pt-pg-summary/37908 "2026-02-03T11:00:34Z")
Hi, I have a pmm3.1 server that monitors a couple of Azure Flexible Server for Postgresql instances, looking at the ‘PostgreSQL Instance Summary’ Dashboard i can see live data, but opening the service-summary pane (that… --- ## [Percona Distribution for PostgreSQL 18 | pgBackRest Restore Issue with Patroni HA](https://forums.percona.com/t/percona-distribution-for-postgresql-18-pgbackrest-restore-issue-with-patroni-ha/39906)
**Author:** [@asad121](https://forums.percona.com/u/asad121)\ **Replies:** 4\ **Last updated:** [January 27, 2026, 7:37pm UTC](https://forums.percona.com/t/percona-distribution-for-postgresql-18-pgbackrest-restore-issue-with-patroni-ha/39906 "2026-01-27T19:37:22Z")
Hi We have installed Percona Distribution for PostgreSQL 18 with High Availability (Patroni) in our test environment as part of our preparation for production. Environment Overview PostgreSQL: Percona Distribution for… --- ## [Is there a way to install a custom PPG image from private repo when using everest to create instances?](https://forums.percona.com/t/is-there-a-way-to-install-a-custom-ppg-image-from-private-repo-when-using-everest-to-create-instances/40113)
**Author:** [@VarshithM](https://forums.percona.com/u/VarshithM)\ **Replies:** 0\ **Last updated:** [January 27, 2026, 11:20am UTC](https://forums.percona.com/t/is-there-a-way-to-install-a-custom-ppg-image-from-private-repo-when-using-everest-to-create-instances/40113 "2026-01-27T11:20:25Z")
I have a custom PPG image based off of the Percona Docker PGDB Dockerfile which installs Paradedb pg\_search extension and custom init scripts. I have the image hosted on our private container registry. We would like to … --- ## [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 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 PMM query analytics is broken](https://forums.percona.com/t/percona-pmm-query-analytics-is-broken/39201)
**Author:** [@aniruddha.deshpande](https://forums.percona.com/u/aniruddha.deshpande)\ **Replies:** 9\ **Last updated:** [August 26, 2025, 3:12pm UTC](https://forums.percona.com/t/percona-pmm-query-analytics-is-broken/39201 "2025-08-26T15:12:50Z")
Description: We are using PMM to monitor our databases. Was using version PMM 3.2.0 & even upgraded to latest version 3.3.1. We see that we are getting below error when we try to look for QAN. And this is persistent acro… --- ## [pgBackRest Path Issue with Percona PostgreSQL Operator 2.7.0](https://forums.percona.com/t/pgbackrest-path-issue-with-percona-postgresql-operator-2-7-0/39173)
**Author:** [@ra2](https://forums.percona.com/u/ra2)\ **Replies:** 1\ **Last updated:** [August 22, 2025, 7:57am UTC](https://forums.percona.com/t/pgbackrest-path-issue-with-percona-postgresql-operator-2-7-0/39173 "2025-08-22T07:57:54Z")
\# pgBackRest Path Issue with Percona PostgreSQL Operator 2.7.0 ## Issue Summary The Percona PostgreSQL Operator 2.7.0 has a critical incompatibility with the pgBackRest image \`percona/percona-pgbackrest:2.55.0\` that pr… --- ## [Pgbackrest another postgresql servers with same backup mchine](https://forums.percona.com/t/pgbackrest-another-postgresql-servers-with-same-backup-mchine/38670)
**Author:** [@esqin\_ceferov](https://forums.percona.com/u/esqin_ceferov)\ **Replies:** 1\ **Last updated:** [August 19, 2025, 1:27pm UTC](https://forums.percona.com/t/pgbackrest-another-postgresql-servers-with-same-backup-mchine/38670 "2025-08-19T13:27:57Z")
hello guys,i have postgres(3node,patroni)servers which i take backup with pgbackrest(bckupserver),now i set up new postgres(3node,patrtoni)and i want backup and restore this postgres with same backup machine,how to do it… --- ## [ERROR: Listing secrets of "https://vault.local:8200" at mountpoint "pg-tde" failed](https://forums.percona.com/t/error-listing-secrets-of-https-vault-local-8200-at-mountpoint-pg-tde-failed/38695)
**Author:** [@typewriter](https://forums.percona.com/u/typewriter)\ **Replies:** 4\ **Last updated:** [July 16, 2025, 11:49am UTC](https://forums.percona.com/t/error-listing-secrets-of-https-vault-local-8200-at-mountpoint-pg-tde-failed/38695 "2025-07-16T11:49:55Z")
Greetings! I have been following the instructions listed in Configure pg\_tde and Vault Configuration to get my PostgreSQL 17 database encrypted using the Percona pg\_tde extension. However, for some reason I’m unable to … --- ## [Postgresql operator and ldap root ca](https://forums.percona.com/t/postgresql-operator-and-ldap-root-ca/38099)
**Author:** [@feca](https://forums.percona.com/u/feca)\ **Replies:** 3\ **Last updated:** [June 4, 2025, 3:35pm UTC](https://forums.percona.com/t/postgresql-operator-and-ldap-root-ca/38099 "2025-06-04T15:35:52Z")
Hi all! I try to use the postgres-operator version 2.6.0 with PerconaPGCluster kind. When I mount the LDAP root ca configmap to the /etc/postgres/ldap/ca.crt path of statefulset, the ldap login works. But hot can I co… --- ## [QAN showing query which are not running during the time range selected](https://forums.percona.com/t/qan-showing-query-which-are-not-running-during-the-time-range-selected/37713)
**Author:** [@aniruddha.deshpande](https://forums.percona.com/u/aniruddha.deshpande)\ **Replies:** 10\ **Last updated:** [May 12, 2025, 2:06pm UTC](https://forums.percona.com/t/qan-showing-query-which-are-not-running-during-the-time-range-selected/37713 "2025-05-12T14:06:44Z")
Hi All, I’m currently facing a rather confusing situation. Issue: While reviewing the Query Analytics (QAN) in PMM3 (and also in PMM 2.x), we noticed that when selecting a specific time range, some queries are being d… --- ## [Reg. Clarification and suggestions for below analysis points](https://forums.percona.com/t/reg-clarification-and-suggestions-for-below-analysis-points/36580)
**Author:** [@Amol](https://forums.percona.com/u/Amol)\ **Replies:** 1\ **Last updated:** [February 7, 2025, 1:04pm UTC](https://forums.percona.com/t/reg-clarification-and-suggestions-for-below-analysis-points/36580 "2025-02-07T13:04:19Z")
Below are the specific points we would like assistance with: Improved Clarity in Query Issue Identification We are looking for ways to gain more clarity in identifying issues related to running queries. Specifically, w… --- ## [Clarification and suggestions on Query analyze and performance](https://forums.percona.com/t/clarification-and-suggestions-on-query-analyze-and-performance/36558)
**Author:** [@Amol](https://forums.percona.com/u/Amol)\ **Replies:** 0\ **Last updated:** [February 5, 2025, 10:21pm UTC](https://forums.percona.com/t/clarification-and-suggestions-on-query-analyze-and-performance/36558 "2025-02-05T22:21:06Z")
I am writing to seek your guidance and suggestions on the following points regarding our Percona setup. We are looking for improvements in identifying and analyzing performance-related issues, particularly with queries, … --- ## [Alert Email body unable to change](https://forums.percona.com/t/alert-email-body-unable-to-change/35638)
**Author:** [@Amol](https://forums.percona.com/u/Amol)\ **Replies:** 5\ **Last updated:** [December 16, 2024, 8:27pm UTC](https://forums.percona.com/t/alert-email-body-unable-to-change/35638 "2024-12-16T20:27:02Z")
We have created template for postgresql database alert.like warnings errors now we received warnings errors but we haven’t recieved in our custom template (hostname) like database server details in email body. --- ## [Vacuum (Full) not working || pg\_tde](https://forums.percona.com/t/vacuum-full-not-working-pg-tde/34507)
**Author:** [@amulla](https://forums.percona.com/u/amulla)\ **Replies:** 8\ **Last updated:** [October 28, 2024, 1:51pm UTC](https://forums.percona.com/t/vacuum-full-not-working-pg-tde/34507 "2024-10-28T13:51:04Z")
Hello Team, When i execute normal vacuum it is working fine. but when try to do vacuum (full) table\_name. this is creating high load and server going in crash recovery and after cancelling that statement server is rea… --- ## [Query plan is not displayed for postgres13 database](https://forums.percona.com/t/query-plan-is-not-displayed-for-postgres13-database/17894)
**Author:** [@raghunath.dhandapani](https://forums.percona.com/u/raghunath.dhandapani)\ **Replies:** 7\ **Last updated:** [October 8, 2024, 7:27am UTC](https://forums.percona.com/t/query-plan-is-not-displayed-for-postgres13-database/17894 "2024-10-08T07:27:18Z")
Hi Folks, I have installed PMM2 recently and added a target ubuntu machine which runs postgreSQL13, Installation went fine, i can see other statistics but not the query plan. When clicking on the plan tab, i am getting … --- ## [Does pg\_stat\_statements extension view needs to be created on all databases](https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260)
**Author:** [@rups](https://forums.percona.com/u/rups)\ **Replies:** 4\ **Last updated:** [August 14, 2024, 4:22pm UTC](https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260 "2024-08-14T16:22:15Z")
Hello, Does the extension needs to be created on each database separately for the QAN to capture the sqls ? ##Reference: Install the extension. psql postgres postgres -c "CREATE EXTENSION pg\_stat\_statements SCHEMA p… --- ## [FATAL: SSL required when connecting to Percona Everest postgres engine](https://forums.percona.com/t/fatal-ssl-required-when-connecting-to-percona-everest-postgres-engine/31763)
**Author:** [@duytq02](https://forums.percona.com/u/duytq02)\ **Replies:** 18\ **Last updated:** [July 29, 2024, 12:22pm UTC](https://forums.percona.com/t/fatal-ssl-required-when-connecting-to-percona-everest-postgres-engine/31763 "2024-07-29T12:22:56Z")
Hi All, Have anyone faced this error when connecting to the postgresql after created it with Percona Everest? psql -h 10.28.130.243 -U postgres psql: error: connection to server at “10.28.130.243”, port 5432 failed: F… --- ## [Azure metrics exporter not working](https://forums.percona.com/t/azure-metrics-exporter-not-working/24273)
**Author:** [@ben5556\_K](https://forums.percona.com/u/ben5556_K)\ **Replies:** 2\ **Last updated:** [July 25, 2024, 6:02am UTC](https://forums.percona.com/t/azure-metrics-exporter-not-working/24273 "2024-07-25T06:02:22Z")
Description: Azure metrics exporter not working Steps to Reproduce: Enable Azure Monitoring technical preview feature. Add managed database service and enable Azure metrics checkbox while doing so. Version: 2.38.0 Log… --- ## [pgbackrest-config configmap is not being generated](https://forums.percona.com/t/pgbackrest-config-configmap-is-not-being-generated/31785)
**Author:** [@kndoni](https://forums.percona.com/u/kndoni)\ **Replies:** 1\ **Last updated:** [July 24, 2024, 11:26am UTC](https://forums.percona.com/t/pgbackrest-config-configmap-is-not-being-generated/31785 "2024-07-24T11:26:03Z")
Hello team, I am trying to set up crunchydata postgresql cluster, operator starts successfully but I am having troubles to set up the pg cluster. I am using this version of operator 2.4.0 and this version of pg cluster… --- ## [Percona postgres values.yaml configuration for pgbackrest backup to aws s3 bucket](https://forums.percona.com/t/percona-postgres-values-yaml-configuration-for-pgbackrest-backup-to-aws-s3-bucket/30083)
**Author:** [@Mate\_Kassa](https://forums.percona.com/u/Mate_Kassa)\ **Replies:** 4\ **Last updated:** [June 10, 2024, 5:08pm UTC](https://forums.percona.com/t/percona-postgres-values-yaml-configuration-for-pgbackrest-backup-to-aws-s3-bucket/30083 "2024-06-10T17:08:37Z")
Dear Community, My problem is that I want to create a full backup into an aws s3 bucket when initialize the db. I created a values in which I was able to deploy a chart with helm successfully, however the default pgback… --- ## [Installing pg\_stat\_monitor extension on FreeBSD](https://forums.percona.com/t/installing-pg-stat-monitor-extension-on-freebsd/29629)
**Author:** [@rups](https://forums.percona.com/u/rups)\ **Replies:** 0\ **Last updated:** [April 8, 2024, 7:45pm UTC](https://forums.percona.com/t/installing-pg-stat-monitor-extension-on-freebsd/29629 "2024-04-08T19:45:56Z")
Description: Hello Team, While trying to build from source code on FreeBSD, I am running into below compilation issues with pg\_stat\_monitor. Can you pls advise. Followed the link here: git clone git://github.com/perc… --- ## [Exact permissions need PMM user on Postgresql?](https://forums.percona.com/t/exact-permissions-need-pmm-user-on-postgresql/28270)
**Author:** [@igorFA](https://forums.percona.com/u/igorFA)\ **Replies:** 1\ **Last updated:** [February 6, 2024, 3:19pm UTC](https://forums.percona.com/t/exact-permissions-need-pmm-user-on-postgresql/28270 "2024-02-06T15:19:12Z")
Description: The official Percona Monitoring and Management (PMM) documentation suggests creating a PMM user with WITH SUPERUSER permission. However, I prefer to avoid granting such extensive permissions. While the PMM a… --- ## [Barman check error](https://forums.percona.com/t/barman-check-error/24285)
**Author:** [@khaled\_ghazy](https://forums.percona.com/u/khaled_ghazy)\ **Replies:** 1\ **Last updated:** [September 26, 2023, 12:03pm UTC](https://forums.percona.com/t/barman-check-error/24285 "2023-09-26T12:03:03Z")
Server pg: WAL archive: FAILED (please make sure WAL shipping is setup) PostgreSQL: OK superuser or standard user with backup privileges: OK PostgreSQL streaming: OK wal\_level: OK replication slot: FAILED (replicat… --- ## [Huge Input lookup Exception when trying to create the Indexes for XML Data type in postgreSQL](https://forums.percona.com/t/huge-input-lookup-exception-when-trying-to-create-the-indexes-for-xml-data-type-in-postgresql/25012)
**Author:** [@Sai\_Teja](https://forums.percona.com/u/Sai_Teja)\ **Replies:** 0\ **Last updated:** [September 7, 2023, 4:34pm UTC](https://forums.percona.com/t/huge-input-lookup-exception-when-trying-to-create-the-indexes-for-xml-data-type-in-postgresql/25012 "2023-09-07T16:34:10Z")
Hi Team, We have one table which is storing XML data with 30k records and stores huge amount of data. We are trying to create the index for this column in the table. But, we’re getting “Huge input Lookup error” during … [Next page](https://forums.percona.com/tag/postgresql/33.md?match_all_tags=true&page=1&tags%5B%5D=postgresql)