This module can be used to manage the installation and configuration of pgpool.
The module leverages augeas to manage the configuration file for pgpool. Additionally it allows you to manage the pool hba configuration file via the augeas pg_hba provider. You can also manage the pool_password file with the pool password resource provided by the module. The module does not manage the installation of the pgdg repository for installation of the latest version of pgpool. You can provide the package name to the pgpool module if you have built your own or would like to leverage a version that is shipped with your OS.
As part of using this module, you will need to have the following modules installed.
Additionally there is a submode that references an external Augeas lense. If you want to check out this module, make sure to recursively fetch the module to get the augeas-pgpool submodule.
git clone --recursive https://github.com/mwhahaha/puppet-pgpool.git
Here is a sample configuration for a streaming replica master/slave setup and pgpool on the same node as the application.
# install the package and the service
class { 'pgpool': }
# setup our pgpool.conf
class { 'pgpool::config::connection': }
class { 'pgpool::config::healthcheck':
health_check_period => 5,
health_check_timeout => 10,
health_check_user => 'pgpool',
health_check_password => 'mypassword',
health_check_max_retries => 1,
}
class { 'pgpool::config::loadbalance':
load_balance_mode => 'on',
}
class { 'pgpool::config::logs':
log_connections => 'on',
log_statement => 'on',
log_min_messages => 'info',
}
class { 'pgpool::config::masterslave':
master_slave_mode => 'on',
master_slave_sub_mode => 'stream',
sr_check_period => 5,
sr_check_user => 'pgpool',
sr_check_password => 'mypassword',
delay_threshold => 1024000,
}
class { 'pgpool::config::pools':
enable_pool_hba => 'on',
}
class { 'pgpool::config::replication':
replication_mode => 'off',
}
class { 'pgpool::config::service':
pid_file_name => '/var/run/pgpool-II-93/pgpool-II-93.pid',
logdir => '/tmp',
}
class { 'pgpool::config::ssl': }
class { 'pgpool::config::watchdog': }
# configure our backend systems
pgpool::config::backend { 'db-n01':
id => '0',
hostname => '10.0.0.4',
port => 5432,
application_name => 'db-n01',
data_directory => '/var/lib/pgsql/9.3/data',
}
pgpool::config::backend { 'db-n02':
id => '1',
hostname => '10.0.0.5',
port => 5432,
application_name => 'db-n02',
data_directory => '/var/lib/pgsql/9.3/data',
}
# configure our application user password access
pgpool::pool_passwd { 'my_app_user':
password_hash => 'md5d6d70ecf643d4sec9ca6623fee1233ea',
}
# configure the pgpool hba configuration
pgpool::hba { 'my_app_user':
type => 'host',
database => 'my_db_name',
user => 'my_app_user',
address => '127.0.0.1/32',
auth_method => 'md5',
}
Here is a list of all the available classes and resources for this module.
Classes:
Resources:
This has only been tested on RedHat/CentOS 6. It might work on Debian/Ubuntu.
Pull requests welcome.
To use pgpool::monitor, the code for the pgpool-monitor package is available from pgpool-monitor.