# \#postgresql **URL:** https://forum.ansible.com/tag/postgresql/115.md [Latest](https://forum.ansible.com/latest.md) · [Categories](https://forum.ansible.com/categories.md) · [Tags](https://forum.ansible.com/tags.md) --- ## [Ansible configuration module for Postgres Client only on RHEL8](https://forum.ansible.com/t/ansible-configuration-module-for-postgres-client-only-on-rhel8/45949)
**Author:** [@pcouas](https://forum.ansible.com/u/pcouas)\ **Replies:** 4\ **Last updated:** [June 19, 2026, 4:17pm UTC](https://forum.ansible.com/t/ansible-configuration-module-for-postgres-client-only-on-rhel8/45949 "2026-06-19T16:17:20Z")
Hello, I search if there is Ansible configuration file for install on RHLE8 server an Postgres client only. Not all postgres Regards --- ## [Issue: AWX cannot connect to Aurora PostgreSQL 17 due to SSL](https://forum.ansible.com/t/issue-awx-cannot-connect-to-aurora-postgresql-17-due-to-ssl/45327)
**Author:** [@Rushabh\_Patel](https://forum.ansible.com/u/Rushabh_Patel)\ **Replies:** 2\ **Last updated:** [March 11, 2026, 2:20pm UTC](https://forum.ansible.com/t/issue-awx-cannot-connect-to-aurora-postgresql-17-due-to-ssl/45327 "2026-03-11T14:20:02Z")
\*\*AWX cannot connect to Aurora PostgreSQL 17 \*\*. Environment AWX Operator Version: (add your version, e.g., 2.19.1) AWX Version: 3.2.0 Kubernetes Version: v1.33 PostgreSQL: AWS Aurora PostgreSQL v17 Deployment: Ext… --- ## [Why postgresql\_query query\_result contains empty dict on empty result?](https://forum.ansible.com/t/why-postgresql-query-query-result-contains-empty-dict-on-empty-result/44757)
**Author:** [@betalb](https://forum.ansible.com/u/betalb)\ **Replies:** 1\ **Last updated:** [November 3, 2025, 7:31am UTC](https://forum.ansible.com/t/why-postgresql-query-query-result-contains-empty-dict-on-empty-result/44757 "2025-11-03T07:31:45Z")
Good day everyone. Wanted to understand rationale behind the decision to return empty dict when query returns no result. Looking through the code I see that this is intentional and explicit (community.postgresql/plugins/… --- ## [Plugin Idea: postgresql\_inventory](https://forum.ansible.com/t/plugin-idea-postgresql-inventory/44621)
**Author:** [@gebz97](https://forum.ansible.com/u/gebz97)\ **Replies:** 4\ **Last updated:** [October 6, 2025, 8:55pm UTC](https://forum.ansible.com/t/plugin-idea-postgresql-inventory/44621 "2025-10-06T20:55:06Z")
Hello Everyone, I’m Gebz (First post on the Ansible forums). I’ve recently started working on a custom plugin for pulling dynamic inventory data from a postgresql table (since I didn’t find any that exist to my knowledg… --- ## [How to properly manage pg\_backup\_start across Ansible tasks for consistent snapshots?](https://forum.ansible.com/t/how-to-properly-manage-pg-backup-start-across-ansible-tasks-for-consistent-snapshots/44081)
**Author:** [@MoralCode](https://forum.ansible.com/u/MoralCode)\ **Replies:** 3\ **Last updated:** [July 24, 2025, 8:34pm UTC](https://forum.ansible.com/t/how-to-properly-manage-pg-backup-start-across-ansible-tasks-for-consistent-snapshots/44081 "2025-07-24T20:34:11Z")
Hello! I’m building a playbook that needs to effectively perform a backup-and-restore style process using filesystem-level snapshots of a PostgreSQL server (in this case the snapshots are done with AWS), and I want to … --- ## [Migrate hosts and inventory from Postgres DB v17.0.1 to latest 24.6.1 release?](https://forum.ansible.com/t/migrate-hosts-and-inventory-from-postgres-db-v17-0-1-to-latest-24-6-1-release/43316)
**Author:** [@Swampcritter](https://forum.ansible.com/u/Swampcritter)\ **Replies:** 2\ **Last updated:** [June 23, 2025, 12:53pm UTC](https://forum.ansible.com/t/migrate-hosts-and-inventory-from-postgres-db-v17-0-1-to-latest-24-6-1-release/43316 "2025-06-23T12:53:20Z")
Is it possible to migrate the hosts and inventory from the Postgres DB running under docker w/ AWX v17.0.1 to the latest AWX v24.6.1 release running under minikube / kubernetes? I have approximately 150+ hosts and sever… --- ## [Can AWX Operator use Aurora Serverless v2 as its database?](https://forum.ansible.com/t/can-awx-operator-use-aurora-serverless-v2-as-its-database/40966)
**Author:** [@satokom](https://forum.ansible.com/u/satokom)\ **Replies:** 1\ **Last updated:** [May 1, 2025, 9:55am UTC](https://forum.ansible.com/t/can-awx-operator-use-aurora-serverless-v2-as-its-database/40966 "2025-05-01T09:55:59Z")
Description of the Issue I am currently using AWX Operator 2.10.0, which, by default, provisions a PostgreSQL 13 database running as a StatefulSet within Kubernetes. This database is automatically managed by the AWX Oper… --- ## [AWX Postgres Ansible Setup Error](https://forum.ansible.com/t/awx-postgres-ansible-setup-error/41810)
**Author:** [@jeremytourville](https://forum.ansible.com/u/jeremytourville)\ **Replies:** 5\ **Last updated:** [April 29, 2025, 2:51pm UTC](https://forum.ansible.com/t/awx-postgres-ansible-setup-error/41810 "2025-04-29T14:51:12Z")
I am setting up AWX in a separate environment from our production one. I have setup the new K8s cluster and copied over the config values from AWX in production and changed hostnames and private repos as needed. When t… --- ## [\[DAB RBAC\] Migration problem from 24.2.1 to 24.3.1 (or above)](https://forum.ansible.com/t/dab-rbac-migration-problem-from-24-2-1-to-24-3-1-or-above/38948)
**Author:** [@mbutton77](https://forum.ansible.com/u/mbutton77)\ **Replies:** 4\ **Last updated:** [December 19, 2024, 8:16am UTC](https://forum.ansible.com/t/dab-rbac-migration-problem-from-24-2-1-to-24-3-1-or-above/38948 "2024-12-19T08:16:09Z")
Hi, We are currently trying to upgrade from 24.2.1 to 24.6.1 but we encoutered a blocking problem during the database migration. (Our database is an external PostgreSQL 12). The migration job is looping and the follo… --- ## [AWX job\_id integer max value 2147483647?](https://forum.ansible.com/t/awx-job-id-integer-max-value-2147483647/8321)
**Author:** [@anon81884396](https://forum.ansible.com/u/anon81884396)\ **Replies:** 5\ **Last updated:** [October 28, 2024, 9:06pm UTC](https://forum.ansible.com/t/awx-job-id-integer-max-value-2147483647/8321 "2024-10-28T21:06:16Z")
Hello! I was curious about the job\_id parameter in AWX, in the postgresql database specifically. I tried to gather information on this myself and I believe I’ve arrived at the conclusion that job\_id in the main\_activity… --- ## [AWX connectivity to AWS RDS Postgres issues when forcing SSL](https://forum.ansible.com/t/awx-connectivity-to-aws-rds-postgres-issues-when-forcing-ssl/10313)
**Author:** [@td784](https://forum.ansible.com/u/td784)\ **Replies:** 0\ **Last updated:** [October 15, 2024, 9:51pm UTC](https://forum.ansible.com/t/awx-connectivity-to-aws-rds-postgres-issues-when-forcing-ssl/10313 "2024-10-15T21:51:05Z")
Hi team, I am having issues with getting the awx\_task deployment, and awx\_web deployment to connect to an AWS RDS database when we enable the rds.force\_ssl: 1 parameter. When this parameter is turned on and we have the… --- ## [Awx- Restore db from external dump file](https://forum.ansible.com/t/awx-restore-db-from-external-dump-file/8584)
**Author:** [@amE\_168](https://forum.ansible.com/u/amE_168)\ **Replies:** 0\ **Last updated:** [September 18, 2024, 8:41am UTC](https://forum.ansible.com/t/awx-restore-db-from-external-dump-file/8584 "2024-09-18T08:41:28Z")
Hi guys, I have a question regarding possible AWX configuration scenarios, I installed an RPM version of ansible , and then the k3s clustered version using minikube. After dumping the DB on the RPM version I would like … --- ## [Calling all Postgres devs - the 2024 State of PostgreSQL Survey is now open! ](https://forum.ansible.com/t/calling-all-postgres-devs-the-2024-state-of-postgresql-survey-is-now-open/8291)
**Author:** [@sarahattimescale](https://forum.ansible.com/u/sarahattimescale)\ **Replies:** 2\ **Last updated:** [September 6, 2024, 6:09pm UTC](https://forum.ansible.com/t/calling-all-postgres-devs-the-2024-state-of-postgresql-survey-is-now-open/8291 "2024-09-06T18:09:44Z")
Hi! I’m reaching out here as I know a lot of folks using Ansible also tend to use PostgreSQL. The 2024 State of PostgreSQL Survey is now open, and we could use your help in responding to it. It’s a community-created su… --- ## [AWX restore failing on 24.6.1 - cannot drop index](https://forum.ansible.com/t/awx-restore-failing-on-24-6-1-cannot-drop-index/7828)
**Author:** [@anon81884396](https://forum.ansible.com/u/anon81884396)\ **Replies:** 1\ **Last updated:** [August 13, 2024, 6:50pm UTC](https://forum.ansible.com/t/awx-restore-failing-on-24-6-1-cannot-drop-index/7828 "2024-08-13T18:50:47Z")
\*\*AWX restore failing with ERROR: cannot drop index \*\* Hello, I’m running AWX 24.6.1 on the 2.19.1 operator. I have a primary and secondary AWX instance I do a daily awxbackup and awxrestore to. This process has been… --- ## [Migrating from External to Managed Database](https://forum.ansible.com/t/migrating-from-external-to-managed-database/7553)
**Author:** [@grepusername](https://forum.ansible.com/u/grepusername)\ **Replies:** 0\ **Last updated:** [July 30, 2024, 12:20pm UTC](https://forum.ansible.com/t/migrating-from-external-to-managed-database/7553 "2024-07-30T12:20:53Z")
Two related questions, for an awx-operator cluster: Is there any way to migrate a database from an external database to an internally/operator managed database and pod? Is there a way to regenerate the secret key if it… --- ## [Login to Postgresql to create a new database](https://forum.ansible.com/t/login-to-postgresql-to-create-a-new-database/7364)
**Author:** [@Jeff8JF](https://forum.ansible.com/u/Jeff8JF)\ **Replies:** 5\ **Last updated:** [July 22, 2024, 1:45pm UTC](https://forum.ansible.com/t/login-to-postgresql-to-create-a-new-database/7364 "2024-07-22T13:45:24Z")
I created the attached plabooks to create a new database auth in my Postgresql server. I use the become\_user: postgres to not need the pass how say de documentation " \* To avoid “Peer authentication failed for user post… --- ## [Unable to connect to postgres using postgesql\_db ansible module](https://forum.ansible.com/t/unable-to-connect-to-postgres-using-postgesql-db-ansible-module/6695)
**Author:** [@Mukesh1328](https://forum.ansible.com/u/Mukesh1328)\ **Replies:** 6\ **Last updated:** [June 22, 2024, 1:34pm UTC](https://forum.ansible.com/t/unable-to-connect-to-postgres-using-postgesql-db-ansible-module/6695 "2024-06-22T13:34:04Z")
Here is the playbook im using - hosts: all become: true tasks: - name: create db become\_user: postgres postgresql\_db: name: test\_db Output after executing the play The full traceback is: Tr… --- ## [How to grant execute on pg\_backup\_start](https://forum.ansible.com/t/how-to-grant-execute-on-pg-backup-start/6105)
**Author:** [@svenna](https://forum.ansible.com/u/svenna)\ **Replies:** 3\ **Last updated:** [May 31, 2024, 4:19pm UTC](https://forum.ansible.com/t/how-to-grant-execute-on-pg-backup-start/6105 "2024-05-31T16:19:27Z")
i am trying to setup pgbackrest with ansible and i have stumbled upon GRANTing EXECUTE on the function pg\_backup\_start i have the following ansible snippet: - name: GRANT EXECUTE on function pg\_start\_backup commu… --- ## [Awx web crash loop backoff - password authentication failed for awx](https://forum.ansible.com/t/awx-web-crash-loop-backoff-password-authentication-failed-for-awx/5726)
**Author:** [@jeremytourville](https://forum.ansible.com/u/jeremytourville)\ **Replies:** 14\ **Last updated:** [May 13, 2024, 1:08pm UTC](https://forum.ansible.com/t/awx-web-crash-loop-backoff-password-authentication-failed-for-awx/5726 "2024-05-13T13:08:27Z")
I had a working/running setup previously. I was running into some issues and needed to troubleshoot. I accidentally deleted my namespace. (Yeah, big oops!) I worked through getting my storage correct and all pods are … --- ## [AWX: Postgres 15 Support & Container Readiness Checks Available!](https://forum.ansible.com/t/awx-postgres-15-support-container-readiness-checks-available/4262)
**Author:** [@rooftopcellist](https://forum.ansible.com/u/rooftopcellist)\ **Replies:** 3\ **Last updated:** [March 8, 2024, 9:30am UTC](https://forum.ansible.com/t/awx-postgres-15-support-container-readiness-checks-available/4262 "2024-03-08T09:30:12Z")
Hey everyone! I just wanted to note a couple big features that have landed in devel in the last week or two that are of note and will end up in the next release. AWX now supports Postgres 15 and it is the default vers… --- ## [PostgreSQL Conference Europe 2023](https://forum.ansible.com/t/postgresql-conference-europe-2023/1978)
**Author:** [@Leo](https://forum.ansible.com/u/Leo)\ **Replies:** 14\ **Last updated:** [January 18, 2024, 12:56pm UTC](https://forum.ansible.com/t/postgresql-conference-europe-2023/1978 "2024-01-18T12:56:13Z")
Hey @PostgreSQLTeam , there is a PostgreSQL Conference Europe coming to Czech republic soon. Sadly the call for papers is closed, so submitting something won’t be possible if you haven’t, but I noticed there is an Ansib… --- ## [The Bullhorn #126](https://forum.ansible.com/t/the-bullhorn-126/3076)
**Author:** [@cybette](https://forum.ansible.com/u/cybette)\ **Replies:** 0\ **Last updated:** [December 27, 2023, 6:09pm UTC](https://forum.ansible.com/t/the-bullhorn-126/3076 "2023-12-27T18:09:28Z")
This week in Ansible Community Issue #126, 2023-12-27 (Past Issues) Welcome to The Bullhorn, our newsletter for the Ansible Community. If you have any questions or content you’d like to share, you’re welcome to chat wit… --- ## [Awx postgress setup via tls certs](https://forum.ansible.com/t/awx-postgress-setup-via-tls-certs/1492)
**Author:** [@Vijender7](https://forum.ansible.com/u/Vijender7)\ **Replies:** 3\ **Last updated:** [October 9, 2023, 11:29am UTC](https://forum.ansible.com/t/awx-postgress-setup-via-tls-certs/1492 "2023-10-09T11:29:21Z")
Hi, Please provide the exact syntax of how to create a postgresql secret for postgresdb with tls.crt, tls.key, ca.crt with db details. I am trying to deploy awx application with ssl enabled external database Regards, … --- ## [Setup and configure PgAdmin with servers and scripts](https://forum.ansible.com/t/setup-and-configure-pgadmin-with-servers-and-scripts/186)
**Author:** [@bunglehaze](https://forum.ansible.com/u/bunglehaze)\ **Replies:** 5\ **Last updated:** [September 15, 2023, 10:50am UTC](https://forum.ansible.com/t/setup-and-configure-pgadmin-with-servers-and-scripts/186 "2023-09-15T10:50:04Z")
Morning all, I am looking around at ways in which i can leverage ansible in order to automate a PGAdmin setup in docker to make configuring it much simpler. The system we have now is: docker-compose to build pgadmin an…