From 1c90c6913652e0ec7489ed22941e4e6a31d55912 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Isma=C3=ABl=20Bouya?= Date: Tue, 15 May 2018 22:37:32 +0200 Subject: Add pgbouncer for backup --- modules/role/templates/backup/pam_ldap_pgbouncer.conf.erb | 7 +++++++ modules/role/templates/backup/pgbouncer.ini.erb | 15 +++++++++++++++ 2 files changed, 22 insertions(+) create mode 100644 modules/role/templates/backup/pam_ldap_pgbouncer.conf.erb create mode 100644 modules/role/templates/backup/pgbouncer.ini.erb (limited to 'modules/role/templates') diff --git a/modules/role/templates/backup/pam_ldap_pgbouncer.conf.erb b/modules/role/templates/backup/pam_ldap_pgbouncer.conf.erb new file mode 100644 index 0000000..12fa9bb --- /dev/null +++ b/modules/role/templates/backup/pam_ldap_pgbouncer.conf.erb @@ -0,0 +1,7 @@ +host <%= @ldap_server %> + +base <%= @ldap_base %> +binddn <%= @ldap_dn %> +bindpw <%= @ldap_password %> +pam_login_attribute <%= @ldap_attribute %> +pam_filter <%= @ldap_filter %> diff --git a/modules/role/templates/backup/pgbouncer.ini.erb b/modules/role/templates/backup/pgbouncer.ini.erb new file mode 100644 index 0000000..3ba8728 --- /dev/null +++ b/modules/role/templates/backup/pgbouncer.ini.erb @@ -0,0 +1,15 @@ +[pgbouncer] + +listen_addr = 0.0.0.0 +listen_port = 5432 + +unix_socket_dir = /run/postgresql +unix_socket_mode = 0777 + +auth_type = pam + +admin_users = postgres +max_client_conn = 100 +default_pool_size = 20 + +[databases] -- cgit v1.2.3