cloud-sql-pgbouncer

christippett/cloud-sql-pgbouncer/google

Terraform Module HCL GOOGLE

Automatically configure and deploy PgBouncer on Google Cloud with this Terraform module

Install

module "cloud-sql-pgbouncer" {

source = "christippett/cloud-sql-pgbouncer/google"

version = "1.2.1"

}

⭐ Source on GitHub 📦 Registry page

README

Terraform PgBouncer for Cloud SQL ![GitHub tag (latest SemVer)](./CHANGELOG.md) ![Terraform Registry](https://registry.terraform.io/modules/christippett/cloud-sql-pgbouncer/) Let Cloud Run wild on your database 🐆 Overview This module creates a Compute Engine instance running PgBouncer that sits in front of a Cloud SQL or self-hosted PostgreSQL instance. Refer to the examples/ sub-directory for a complete example of how this module can be integrated and used with Cloud SQL. ``hcl module "pgbouncer" { source = "christippett/cloud-sql-pgbouncer/google" version = "~>1.2" project = var.project name = "pgbouncer" zone = "us-central1-a" subnetwork = "subnet-1" machine_type = "f1-micro" port = 25128 database_host = 5432 users = [ { name = "admin", password = "password", admin = true }, { name = "u

Inputs (24)

Name	Type	Description	Default
project	string	The ID of the project where PgBouncer will be created.	required
database_host	string	The host address of the Cloud SQL instance to connect to.	required
zone	string	The zone where PgBouncer will be created.	required
port	number	The port used by PgBouncer to listen on.	required
users	list(string)	The list of users to be created in PgBouncer's userlist.txt. Passwords can be pr	required
name	string	The name of the PgBouncer instance.	required
auth_user	string	Any user not specified in `users` will be queried through the `auth_query` query	`null`
pool_mode	string	Specifies when a server connection can be reused by other clients. Possible valu	`"transaction"`
subnetwork	string	The name or self-link of the subnet where PgBouncer will be created. Either netw	`null`
public_ip_address	string	The public IP address to assign to the PgBouncer instance. If not given, one wil	`null`
machine_type	string	The machine type of PgBouncer instances.	`"f1-micro"`
service_account_scopes	string	A list of service scopes to apply to the PgBouncer instance. Default is the full	`null`
disable_service_account	bool	Flag to disable attaching a service account to the PgBouncer instance.	`false`
auth_query	string	Query to load user’s password from database.	`null`
max_client_connections	number	Maximum number of client connections allowed.	`100`
disable_public_ip	bool	Flag to disable the PgBouncer instance from being assigned an external, public I	`false`
pgbouncer_custom_config	string	Custom PgBouncer configuration values to be appended to `pgbouncer.ini`.	`""`
pgbouncer_image_tag	string	The tag to use for the base PgBouncer `edoburu/pgbouncer` Docker image used by t	`"latest"`
tags	list(string)	A list of tags to assign to PgBouncer instances.	`[]`
default_pool_size	number	Maximum number of server connections to allow per user/database pair.	`20`
max_db_connections	number	The maximum number of server connections per database (regardless of user). 0 is	`0`
boot_image	string	The boot image used by PgBouncer instances. Defaults to the latest LTS Container	`"cos-cloud/cos-89-lts"`
service_account_email	string	The service account e-mail address. If not given, the default Google Compute Eng	`null`
module_depends_on	list(any)	List of modules or resources this module depends on.	`[]`