# \#postgres **URL:** https://forums.percona.com/tag/postgres/17.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… --- ## [\[PPGC\] Adding loadBalancerIP into proxy.pgBouncer.expose specs](https://forums.percona.com/t/ppgc-adding-loadbalancerip-into-proxy-pgbouncer-expose-specs/40677)
**Author:** [@b.balmon](https://forums.percona.com/u/b.balmon)\ **Replies:** 1\ **Last updated:** [April 20, 2026, 12:42pm UTC](https://forums.percona.com/t/ppgc-adding-loadbalancerip-into-proxy-pgbouncer-expose-specs/40677 "2026-04-20T12:42:19Z")
Description: Hi, I have been trying to manage the LoadBalancerIPs of my PPGC Clusters. I am using Octavia as the LoadBalancer Controller with Openstack. In order to control the IP of the PPGC Cluster LoadBalancer Serv… --- ## [Turn off SSL when connecting to bouncer](https://forums.percona.com/t/turn-off-ssl-when-connecting-to-bouncer/21851)
**Author:** [@scott\_molinari](https://forums.percona.com/u/scott_molinari)\ **Replies:** 16\ **Last updated:** [February 10, 2026, 8:49pm UTC](https://forums.percona.com/t/turn-off-ssl-when-connecting-to-bouncer/21851 "2026-02-10T20:49:08Z")
Hi, I’m new to the database operator scene. I have two questions. I’m getting this error when connecting to the bouncer service. ERROR: SQLSTATE\[08006\] \[7\] connection to server at "postgres-db-pg-db-pgbouncer.postgres… --- ## [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… --- ## [PMM3 Postgresql custom queries](https://forums.percona.com/t/pmm3-postgresql-custom-queries/40065)
**Author:** [@makuartur](https://forums.percona.com/u/makuartur)\ **Replies:** 6\ **Last updated:** [January 20, 2026, 5:00pm UTC](https://forums.percona.com/t/pmm3-postgresql-custom-queries/40065 "2026-01-20T17:00:32Z")
Description: I am trying to configure the execution of a PostgreSQL query using pmm-agent (via its built-in postgresql\_exporter). The problem is that database auto-discovery is enabled and works as expected, but my query… --- ## [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? --- ## [Secure exporter endpoint using web.config](https://forums.percona.com/t/secure-exporter-endpoint-using-web-config/19999)
**Author:** [@jesus-velez](https://forums.percona.com/u/jesus-velez)\ **Replies:** 7\ **Last updated:** [July 28, 2025, 4:43pm UTC](https://forums.percona.com/t/secure-exporter-endpoint-using-web-config/19999 "2025-07-28T16:43:58Z")
Hello, Is there a way to secure the endpoints exposed by the exporters by using the default security toolkit that is available on the newer versions of the node-exporter, postgres-exporter and mysqld-exporter? Regards, … --- ## [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 … --- ## [How to create Percona Postgres HA cluster with Docker on 3 nodes?](https://forums.percona.com/t/how-to-create-percona-postgres-ha-cluster-with-docker-on-3-nodes/38604)
**Author:** [@bluepuma77](https://forums.percona.com/u/bluepuma77)\ **Replies:** 2\ **Last updated:** [July 12, 2025, 2:52am UTC](https://forums.percona.com/t/how-to-create-percona-postgres-ha-cluster-with-docker-on-3-nodes/38604 "2025-07-12T02:52:18Z")
There is great documentation about running Percona Postgres in Docker Run Percona Distribution for PostgreSQL in a Docker container - v15 Run Percona Distribution for PostgreSQL in a Docker container - v17 And there i… --- ## [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… --- ## [Create DB and Users at start](https://forums.percona.com/t/create-db-and-users-at-start/23360)
**Author:** [@Satheesh\_Kumar](https://forums.percona.com/u/Satheesh_Kumar)\ **Replies:** 1\ **Last updated:** [May 20, 2025, 1:58pm UTC](https://forums.percona.com/t/create-db-and-users-at-start/23360 "2025-05-20T13:58:07Z")
Hi I am using pg-db and pg-operator and installing using helm but what i want is i need to create few database and users at start I saw the options in values.yaml users: name: pg databases: zoo options: “SUPERUSE… --- ## [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… --- ## [Pg\_stat\_monitor 2.1.0 - Segmentation fault](https://forums.percona.com/t/pg-stat-monitor-2-1-0-segmentation-fault/36247)
**Author:** [@shigaev.s](https://forums.percona.com/u/shigaev.s)\ **Replies:** 11\ **Last updated:** [April 17, 2025, 2:52pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-1-0-segmentation-fault/36247 "2025-04-17T14:52:01Z")
Hello! There is a PostgreSQL 15.4 cluster with Patroni. Installed packages: percona-haproxy/unknown,now 2:2.8.1-1.jammy amd64 \[installed, can be upgraded to: 2:2.8.11-1.jammy\] percona-patroni/unknown,now 1:3.1.0-1.jamm… --- ## [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, … --- ## [Postgis on percona 17 docker image](https://forums.percona.com/t/postgis-on-percona-17-docker-image/36488)
**Author:** [@glay](https://forums.percona.com/u/glay)\ **Replies:** 0\ **Last updated:** [February 3, 2025, 3:56am UTC](https://forums.percona.com/t/postgis-on-percona-17-docker-image/36488 "2025-02-03T03:56:07Z")
Hi, I’m looking at using the percona postgresql docker image and noticed that the image does not include postgis. I am looking to extend the docker image and include postgis along with timescaleDB and although I can get… --- ## [How to use PG17 pg\_tde with Docker?](https://forums.percona.com/t/how-to-use-pg17-pg-tde-with-docker/35765)
**Author:** [@masashi.kayahara](https://forums.percona.com/u/masashi.kayahara)\ **Replies:** 3\ **Last updated:** [December 24, 2024, 6:26am UTC](https://forums.percona.com/t/how-to-use-pg17-pg-tde-with-docker/35765 "2024-12-24T06:26:58Z")
Hi, I created the docker-compose file by referring to the following documentation. URL : Install - pg\_tde documentation version: '3.8' services: db: image: perconalab/pg\_tde:latest container\_name: percona\_po… --- ## [Backup page is throwing 500 error for PostgreSQL](https://forums.percona.com/t/backup-page-is-throwing-500-error-for-postgresql/35414)
**Author:** [@beta-auction](https://forums.percona.com/u/beta-auction)\ **Replies:** 3\ **Last updated:** [December 12, 2024, 12:27pm UTC](https://forums.percona.com/t/backup-page-is-throwing-500-error-for-postgresql/35414 "2024-12-12T12:27:08Z")
I recently upgraded from 1.1.1 to 1.2.0 then to 1.3.0 Went to PostgreSQL database that was running and had backup, now pages shows that i don’t have any backups. saw network calls and /backup was throwing 500 error with… --- ## [QAN Not showing any data for the Service/DB](https://forums.percona.com/t/qan-not-showing-any-data-for-the-service-db/35125)
**Author:** [@Thomas\_Baran](https://forums.percona.com/u/Thomas_Baran)\ **Replies:** 5\ **Last updated:** [December 4, 2024, 7:29am UTC](https://forums.percona.com/t/qan-not-showing-any-data-for-the-service-db/35125 "2024-12-04T07:29:30Z")
Description: PMM QAN won’t show the service/db of a specific Postgres Target any further after a few hours of it working. Tried performing a reboot of my ec2 instance which is running the pmm docker, didn’t help any.. p… --- ## [Patroni -Postgres- HA cluster over 2 DC](https://forums.percona.com/t/patroni-postgres-ha-cluster-over-2-dc/34957)
**Author:** [@Ishan\_Chawla](https://forums.percona.com/u/Ishan_Chawla)\ **Replies:** 1\ **Last updated:** [December 3, 2024, 9:08am UTC](https://forums.percona.com/t/patroni-postgres-ha-cluster-over-2-dc/34957 "2024-12-03T09:08:09Z")
What we want to establish is a redundant setup spread over our two availability zones. With a automatic failover when a server or a availability zone fails. The zone hosting the HA Proxy servers is a stretch over both a… --- ## [PMM - Postgres Alarm creation for row lock contention](https://forums.percona.com/t/pmm-postgres-alarm-creation-for-row-lock-contention/35169)
**Author:** [@Mata\_pg](https://forums.percona.com/u/Mata_pg)\ **Replies:** 2\ **Last updated:** [November 22, 2024, 11:37am UTC](https://forums.percona.com/t/pmm-postgres-alarm-creation-for-row-lock-contention/35169 "2024-11-22T11:37:31Z")
Hi, I would need to implement an alter so that it is notified when a contention lasts more than a certain number of minutes, and therefore probably will not resolve itself, but could block the table indefinitely. I trie… --- ## [Create a custom dashboard for monitoring Freeable Memory for all RDS Postgres instance](https://forums.percona.com/t/create-a-custom-dashboard-for-monitoring-freeable-memory-for-all-rds-postgres-instance/34210)
**Author:** [@Mata\_pg](https://forums.percona.com/u/Mata_pg)\ **Replies:** 2\ **Last updated:** [October 8, 2024, 12:21pm UTC](https://forums.percona.com/t/create-a-custom-dashboard-for-monitoring-freeable-memory-for-all-rds-postgres-instance/34210 "2024-10-08T12:21:10Z")
Hi to all! I am trying to create a custom dashboard to set an alert on the Freeable Memory metric on all RDS Postgres instances. I tried to use the “metrics” datasource, and in particular the “rdsosmetrics\_memory\_free”… --- ## [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 … --- ## [Pg\_stat\_monitor paln option guc registration](https://forums.percona.com/t/pg-stat-monitor-paln-option-guc-registration/33311)
**Author:** [@ysh648](https://forums.percona.com/u/ysh648)\ **Replies:** 0\ **Last updated:** [September 24, 2024, 6:04am UTC](https://forums.percona.com/t/pg-stat-monitor-paln-option-guc-registration/33311 "2024-09-24T06:04:27Z")
Hello, I am using pg\_stat\_monitor. I need explain information, so I am using it after activating the option. I would like to register guc to activate the general plaintext part with various options. Is there a reason … --- ## [PostgreSQL 16.4 Update failed due to missing telemetry package](https://forums.percona.com/t/postgresql-16-4-update-failed-due-to-missing-telemetry-package/33028)
**Author:** [@Juergen\_Flint](https://forums.percona.com/u/Juergen_Flint)\ **Replies:** 2\ **Last updated:** [September 10, 2024, 1:07pm UTC](https://forums.percona.com/t/postgresql-16-4-update-failed-due-to-missing-telemetry-package/33028 "2024-09-10T13:07:50Z")
When trying to install the current version PostgreSQL 16.4, I get the error: Problem: package percona-postgresql16-server-1:16.4-1.el8.x86\_64 from ppg-16-release-x86\_64 requires percona-pg-telemetry16, but none of the p… --- ## [Manually restoring multiple times is not working](https://forums.percona.com/t/manually-restoring-multiple-times-is-not-working/27301)
**Author:** [@Shaurya\_Goel1](https://forums.percona.com/u/Shaurya_Goel1)\ **Replies:** 4\ **Last updated:** [September 6, 2024, 9:53am UTC](https://forums.percona.com/t/manually-restoring-multiple-times-is-not-working/27301 "2024-09-06T09:53:45Z")
Description: I did a manual backup by creating a PerconaPGBackup object. Then, I deleted a table from the database and tried to restore it manually into the cluster which is running by creating a PerconaPGRestore object.… --- ## [Postgresql\_pgstatmonitor\_agent running on port 0](https://forums.percona.com/t/postgresql-pgstatmonitor-agent-running-on-port-0/32061)
**Author:** [@Mendbayar\_Alzakhgui](https://forums.percona.com/u/Mendbayar_Alzakhgui)\ **Replies:** 1\ **Last updated:** [August 6, 2024, 8:56am UTC](https://forums.percona.com/t/postgresql-pgstatmonitor-agent-running-on-port-0/32061 "2024-08-06T08:56:54Z")
Hi, I registered the postgres pmm-agent to percona server the system level information is okay but the service level data not received, then I checked the pmm-admin list then: Agent type Stat… --- ## [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… --- ## [PMM DBaaS for Postgress DB](https://forums.percona.com/t/pmm-dbaas-for-postgress-db/22289)
**Author:** [@ivan.farinic](https://forums.percona.com/u/ivan.farinic)\ **Replies:** 3\ **Last updated:** [July 23, 2024, 7:43pm UTC](https://forums.percona.com/t/pmm-dbaas-for-postgress-db/22289 "2024-07-23T19:43:04Z")
Hello Folks, is there anybody who can help me? it would be possible create postgress DB via DBaaS on PMM ? (in the same way as mysql or mongo). Thanks --- ## [Erro permission pgbackrest](https://forums.percona.com/t/erro-permission-pgbackrest/31242)
**Author:** [@Roger\_Fialho](https://forums.percona.com/u/Roger_Fialho)\ **Replies:** 2\ **Last updated:** [June 26, 2024, 7:44pm UTC](https://forums.percona.com/t/erro-permission-pgbackrest/31242 "2024-06-26T19:44:34Z")
Hello, I’ve checked several forums but no solution. Has anyone experienced this and managed to resolve it? Thank you. 2024-06-25 18:27:20.820 EDT \[18064\] DETAIL: The failed archive command was: pgbackrest --stanza=bk… [Next page](https://forums.percona.com/tag/postgres/17.md?match_all_tags=true&page=1&tags%5B%5D=postgres)