lesovsky/ansible-pgbouncer

Install PgBouncer (database pool software) with Ansible

Howdy! 😃

I'm Alexey.

• ❤ Love: Software design and engineering, databases, monitoring, troubleshooting, data visualization, web development.

• 🤔 Hobbies: Outdoor activity, mountains, travels, mountain bike, snowboarding, coffee, books and more...

• ⚙️ Projects:

  • 💻 Pgcenter - Command-line admin tool for observing and troubleshooting Postgres. Development suspended, transferring to PostgresPro.
  • ☠️ Noisia - Harmful workload generator for PostgreSQL. Development suspended, transferring to PostgresPro.
  • 📡 pgSCV - a multi-purpose metrics exporter for Prometheus, Victoriametrics. Archived.
  • 🚀 pgstats.ru - PostgreSQL Observability Tools. Transferred to PostgresPro.
  • 🐘 Weaponry - terminated in Jan 2022.

• 📝 Blogs, notes, books:

  • PostgreSQL Monitoring (RU) - book about PostgreSQL monitoring tools and approaches (2023).
  • Telegram (RU) - small posts, thoughts, notes, useful links.
  • Habrahabr (RU) - series of posts about Linux, PostgreSQL, monitoring, etc.
  • Getting Started With Ovirt 3.3 (EN) - first book about KVM-based virtualization tool called oVirt (2013).

• ⚒️ Career:

  • 2022.07 - now - Database/Software Engineer at PostgresPro.
  • 2022.01 - 2022.07 - Software Engineer at Coins.ph.
  • 2021.09 - 2021.12 - Devops and Software Engineer at Wildberries.
  • 2014.01 - 2021.09 - PostgreSQL DBA at Data Egret.

ansible-pgbouncer's Issues

Combine with Debian install role?

Hi @lesovsky,

I would like to add Debian/Ubuntu support to this role so that I can use it on our systems. Would you be interested in merging a pull request that adds the following features?

• Rename tasks/install.yml to tasks/install_centos.yml
• Add a tasks/install_debian.yml
• In tasks/main.yml, include the proper install script based on the ansible_os_family

In addition, I would like to add the ability to specify a list of auth_users and password hashes, rather than read the hashes from the DB. The reason for this is that we use a 'centralized' pgbouncer server to pool connections across multiple DB servers. It is therefore challenging to read the pg_shadow table from each database.

Let me know if you would be interested in accepting these changes.

Thank you.