# PostgreSQL General Discussion **URL:** https://forums.percona.com/c/postgresql/postgresql-general-discussion/41.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 General Discussion category](https://forums.percona.com/t/about-the-postgresql-general-discussion-category/46)
**Author:** [@system](https://forums.percona.com/u/system)\ **Replies:** 0
For general PostgreSQL questions, meaning those not specific to Percona’s Distribution for PostgreSQL. --- ## [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 … --- ## [ERROR: permission denied for table \](https://forums.percona.com/t/error-permission-denied-for-table-tablename/40684)
**Author:** [@jruffer](https://forums.percona.com/u/jruffer)\ **Replies:** 3\ **Last updated:** [April 21, 2026, 9:28am UTC](https://forums.percona.com/t/error-permission-denied-for-table-tablename/40684 "2026-04-21T09:28:35Z")
grant select on all tables in schema schemaname to username; I don’t unserstand what I’m missing. --- ## [Table partitioning - is there any way to crate partition table manually](https://forums.percona.com/t/table-partitioning-is-there-any-way-to-crate-partition-table-manually/30067)
**Author:** [@madhan\_joe](https://forums.percona.com/u/madhan_joe)\ **Replies:** 2\ **Last updated:** [July 30, 2025, 1:28pm UTC](https://forums.percona.com/t/table-partitioning-is-there-any-way-to-crate-partition-table-manually/30067 "2025-07-30T13:28:45Z")
hi, in postgresql db how to avoid to create partition table manually is there any way to automate the partition table creation --- ## [Is it possible to create a user-defined function where input and output type may vary?](https://forums.percona.com/t/is-it-possible-to-create-a-user-defined-function-where-input-and-output-type-may-vary/30873)
**Author:** [@jruffer](https://forums.percona.com/u/jruffer)\ **Replies:** 2\ **Last updated:** [June 7, 2024, 1:17pm UTC](https://forums.percona.com/t/is-it-possible-to-create-a-user-defined-function-where-input-and-output-type-may-vary/30873 "2024-06-07T13:17:57Z")
I would like to create a function that might be called with varchar or numeric input. The output type should match the input. Is this possible? --- ## [Looking for opinions/experiences on the best flavor of Linux for PostgreSQL](https://forums.percona.com/t/looking-for-opinions-experiences-on-the-best-flavor-of-linux-for-postgresql/30071)
**Author:** [@estegmey](https://forums.percona.com/u/estegmey)\ **Replies:** 1\ **Last updated:** [May 7, 2024, 1:29pm UTC](https://forums.percona.com/t/looking-for-opinions-experiences-on-the-best-flavor-of-linux-for-postgresql/30071 "2024-05-07T13:29:39Z")
Looking to standardize on the most stable and performant flavor of Linux for enterprise level PostgreSQL. Currently running on CentOS 7 :face\_vomiting: and looking for best upgrade options. Considering Ubuntu, RHEL, OE… --- ## [PostgreSQL equivalent of ArcPy search cursor](https://forums.percona.com/t/postgresql-equivalent-of-arcpy-search-cursor/8285)
**Author:** [@soumyarani](https://forums.percona.com/u/soumyarani)\ **Replies:** 2\ **Last updated:** [November 23, 2020, 7:18pm UTC](https://forums.percona.com/t/postgresql-equivalent-of-arcpy-search-cursor/8285 "2020-11-23T19:18:32Z")
Does anyone know of an equivalent to ArcPy’s search cursor in PostgreSQL? I’ve moved from using Arc to PostGIS/QGIS for the first time and have a task that would have been perfect for search cursor but have no idea if t… --- ## [Can't get webinar - looking for link](https://forums.percona.com/t/cant-get-webinar-looking-for-link/25655)
**Author:** [@PA\_l](https://forums.percona.com/u/PA_l)\ **Replies:** 6\ **Last updated:** [November 30, 2023, 1:56pm UTC](https://forums.percona.com/t/cant-get-webinar-looking-for-link/25655 "2023-11-30T13:56:00Z")
Hi all, I want to view this webinar Building a Serverless PostgreSQL with Neon Tech Open Source and Percona Builds? participants: Vadim Tkachenko (Percona CTO) and Stas Kelvich (Neon co-founder) I have tried to reg… --- ## [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… --- ## [Pgbouncer configuration with scrum-sha run time authentication](https://forums.percona.com/t/pgbouncer-configuration-with-scrum-sha-run-time-authentication/20730)
**Author:** [@MRizwanShaukat](https://forums.percona.com/u/MRizwanShaukat)\ **Replies:** 2\ **Last updated:** [March 22, 2023, 11:40am UTC](https://forums.percona.com/t/pgbouncer-configuration-with-scrum-sha-run-time-authentication/20730 "2023-03-22T11:40:09Z")
we are using percona postgres 14.6, we intended to authenticate from DB directly using run time query with SCRUM SHA, please share any document or steps to configure it. Regards, --- ## [Pgbouncer configuration](https://forums.percona.com/t/pgbouncer-configuration/18904)
**Author:** [@Viktor\_Kucher](https://forums.percona.com/u/Viktor_Kucher)\ **Replies:** 4\ **Last updated:** [December 6, 2022, 9:53am UTC](https://forums.percona.com/t/pgbouncer-configuration/18904 "2022-12-06T09:53:49Z")
Hi, I would like to set custom parameters for pgbouncer like for postgres Is it possible do it in code instead of modify specific config map and restart pgbouncer pods? Thanks in advance --- ## [Pg\_stat\_monitor om an existing postgres container](https://forums.percona.com/t/pg-stat-monitor-om-an-existing-postgres-container/14585)
**Author:** [@Tamar\_Nirenberg](https://forums.percona.com/u/Tamar_Nirenberg)\ **Replies:** 0\ **Last updated:** [March 1, 2022, 10:48am UTC](https://forums.percona.com/t/pg-stat-monitor-om-an-existing-postgres-container/14585 "2022-03-01T10:48:35Z")
Hi, I have postgresql v.13 installed in a docker container. I have enabled the pg\_stats\_statement extension for this postgres, and saw that pg\_stat\_monitor is avialable now. Can it be enabled inside my container? Tha… --- ## [Sync PostgreSQL db using pt-table-sync (like for MySQL)](https://forums.percona.com/t/sync-postgresql-db-using-pt-table-sync-like-for-mysql/13727)
**Author:** [@ocgltd](https://forums.percona.com/u/ocgltd)\ **Replies:** 1\ **Last updated:** [January 18, 2022, 11:24am UTC](https://forums.percona.com/t/sync-postgresql-db-using-pt-table-sync-like-for-mysql/13727 "2022-01-18T11:24:12Z")
I am using the Percona Toolkit (pt-table-sync) to synchronize two MySQL databases from Master to Slave. I would now like to do the same with two PostgreSQL databases. I see that the “Percona Toolkit” says it supports P… --- ## [Looking an upgrade plan for posgreSQL 9.3/postgis 2.1 to latest possible versions](https://forums.percona.com/t/looking-an-upgrade-plan-for-posgresql-9-3-postgis-2-1-to-latest-possible-versions/9228)
**Author:** [@ja2027](https://forums.percona.com/u/ja2027)\ **Replies:** 2\ **Last updated:** [January 18, 2022, 4:56am UTC](https://forums.percona.com/t/looking-an-upgrade-plan-for-posgresql-9-3-postgis-2-1-to-latest-possible-versions/9228 "2022-01-18T04:56:14Z")
I am currently using PostgreSQL 9.3/PostGIS2.1. I want to upgrade to PG13. Could we able to upgrade to 13.x directly? Any help is appreciated. --- ## [Install timescaledb](https://forums.percona.com/t/install-timescaledb/12592)
**Author:** [@edn](https://forums.percona.com/u/edn)\ **Replies:** 1\ **Last updated:** [October 15, 2021, 5:28am UTC](https://forums.percona.com/t/install-timescaledb/12592 "2021-10-15T05:28:44Z")
Hello, Anyone know how to install TimescaleDB on a percona-postgresql-13? If I install it regarding to the docs on TimescaleDB I’ve a dependency problem: # apt install timescaledb-2-2.4.2-postgresql-13 Reading package… --- ## [PostgreSQL Extension Enquiry](https://forums.percona.com/t/postgresql-extension-enquiry/12594)
**Author:** [@Z1234](https://forums.percona.com/u/Z1234)\ **Replies:** 0\ **Last updated:** [October 15, 2021, 1:26am UTC](https://forums.percona.com/t/postgresql-extension-enquiry/12594 "2021-10-15T01:26:11Z")
\-I have been trying to find some interest in a PostgreSQL Extension Project that I hope to get going. I have submitted a post, and am still waiting and hoping for an active reply! It is at: https://forums.percona.com… --- ## [Big performance problems of a moderately complex query](https://forums.percona.com/t/big-performance-problems-of-a-moderately-complex-query/12371)
**Author:** [@manstt](https://forums.percona.com/u/manstt)\ **Replies:** 5\ **Last updated:** [October 5, 2021, 1:41pm UTC](https://forums.percona.com/t/big-performance-problems-of-a-moderately-complex-query/12371 "2021-10-05T13:41:04Z")
Greetings to all, I am here to propose a problem that I cannot solve on the postgres database. We have an application that originally used the oracle database and we hadn’t noticed any particular speed problems. We we… --- ## [PT Online Schema Change for Postgres?](https://forums.percona.com/t/pt-online-schema-change-for-postgres/10081)
**Author:** [@davvblack](https://forums.percona.com/u/davvblack)\ **Replies:** 2\ **Last updated:** [June 21, 2021, 1:27pm UTC](https://forums.percona.com/t/pt-online-schema-change-for-postgres/10081 "2021-06-21T13:27:19Z")
Howdy, is there an equivalent of PTOSC for postgres? I used to use it for MySQL and found it incredibly helpful, but haven’t found anything equivalent for postgres. Is this on the roadmap (or even better, is there secre… --- ## [PostgreSQL session at Percona live - deep dive into internals](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661)
**Author:** [@PA\_l](https://forums.percona.com/u/PA_l)\ **Replies:** 10\ **Last updated:** [June 9, 2021, 7:25pm UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661 "2021-06-09T19:25:11Z")
Hi all, There was a session at Percona live that I watched - didn’t note down speaker or topic… (Doh, slaps forehead…). Anyway, it was this guy who went really down to the internals of PG - looking at records at the by… --- ## [Regarding for PostgreSQL Adminitration](https://forums.percona.com/t/regarding-for-postgresql-adminitration/8009)
**Author:** [@aartiyadav](https://forums.percona.com/u/aartiyadav)\ **Replies:** 5\ **Last updated:** [April 22, 2021, 7:35am UTC](https://forums.percona.com/t/regarding-for-postgresql-adminitration/8009 "2021-04-22T07:35:02Z")
Hello All, I want to learn PostgreSQL and looking for paid/free tutorial or suggest me any online book. Can anyone help me. --- ## [Pgbackrest, when can I clean up old archive wal files](https://forums.percona.com/t/pgbackrest-when-can-i-clean-up-old-archive-wal-files/9018)
**Author:** [@wklingler](https://forums.percona.com/u/wklingler)\ **Replies:** 1\ **Last updated:** [February 1, 2021, 12:51pm UTC](https://forums.percona.com/t/pgbackrest-when-can-i-clean-up-old-archive-wal-files/9018 "2021-02-01T12:51:52Z")
I am looking at moving my Postgres backups to pgbackups. I just want to make sure I understand when I can clean out old archive wal files. I think the rule is any wal file older that the last full backup I want can be … --- ## [Pmm@postgres ERROR: relation "pg\_stat\_statements" does not exist at character 753](https://forums.percona.com/t/pmm-postgres-error-relation-pg-stat-statements-does-not-exist-at-character-753/8722)
**Author:** [@Gunks535](https://forums.percona.com/u/Gunks535)\ **Replies:** 4\ **Last updated:** [January 13, 2021, 1:26am UTC](https://forums.percona.com/t/pmm-postgres-error-relation-pg-stat-statements-does-not-exist-at-character-753/8722 "2021-01-13T01:26:08Z")
Hello, Any one can help me for my problem on postgresql using pmm-admin, I got the error log, 2021-01-11 13:25:00.013 WIB \[19845\] pmm@postgres ERROR: relation "pg\_stat\_statements" does not exist at character 753 2021… --- ## [Backup reports](https://forums.percona.com/t/backup-reports/8267)
**Author:** [@skiz79](https://forums.percona.com/u/skiz79)\ **Replies:** 2\ **Last updated:** [January 8, 2021, 1:02pm UTC](https://forums.percona.com/t/backup-reports/8267 "2021-01-08T13:02:25Z")
Hi, I am trying to setup reports for my daily backups of Postgres DBs. Is there such a feature in PMM? --- ## [How to integrate Oracle EBS ( version 12.1.3) to allow login using keycloak as SSO?](https://forums.percona.com/t/how-to-integrate-oracle-ebs-version-12-1-3-to-allow-login-using-keycloak-as-sso/8317)
**Author:** [@rahulroy99](https://forums.percona.com/u/rahulroy99)\ **Replies:** 1\ **Last updated:** [December 2, 2020, 9:49am UTC](https://forums.percona.com/t/how-to-integrate-oracle-ebs-version-12-1-3-to-allow-login-using-keycloak-as-sso/8317 "2020-12-02T09:49:18Z")
Oracle EBS allows SAML for integration as per the documentation and keycloak is also using SAML. --- ## [Working with Aiven to connect databases?](https://forums.percona.com/t/working-with-aiven-to-connect-databases/8088)
**Author:** [@food\_lover](https://forums.percona.com/u/food_lover)\ **Replies:** 1\ **Last updated:** [September 29, 2020, 8:53am UTC](https://forums.percona.com/t/working-with-aiven-to-connect-databases/8088 "2020-09-29T08:53:53Z")
Which databases do you work with? I’m thinking about buying a server for a project at university, but I don’t know if it will pay off. Servers only have limited storage space, but databases are virtually infinite. With … --- ## [huge\_pages and postgres on k8s](https://forums.percona.com/t/huge-pages-and-postgres-on-k8s/7938)
**Author:** [@bmath](https://forums.percona.com/u/bmath)\ **Replies:** 1\ **Last updated:** [August 25, 2020, 12:27am UTC](https://forums.percona.com/t/huge-pages-and-postgres-on-k8s/7938 "2020-08-25T00:27:17Z")
Hello Percona folks! Brian Matheson from MayaData here. I have some general questions about Postgres on k8s as well as some questions specific to Percona’s offerings. First off, I’m running under k8s with a 5.4 kern… --- ## [We're not just about Percona products!](https://forums.percona.com/t/were-not-just-about-percona-products/7749)
**Author:** [@Tom\_Basil](https://forums.percona.com/u/Tom_Basil)\ **Replies:** 1\ **Last updated:** [July 14, 2020, 4:18am UTC](https://forums.percona.com/t/were-not-just-about-percona-products/7749 "2020-07-14T04:18:12Z")
If you'd like to ask generic questions about PostgreSQL we'd be happy to help!