1. Overview
2. Module Description - What the module does and why it is useful
3. Setup - The basics of getting started with pgpool
   • Setup requirements
4. Usage - Configuration options and additional functionality
5. Reference - An under-the-hood peek at what the module is doing and how
6. Limitations - OS compatibility, etc.
7. Development - Guide for contributing to the module.

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.

• camptocamp/augeas
• puppetlabs/stdlib
• herculesteam/augeasproviders_core
• herculesteam/augeasproviders_postgresql

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,
  data_directory => '/var/lib/pgsql/9.3/data',
}
pgpool::config::backend { 'db-n02':
  id             => '1',
  hostname       => '10.0.0.5',
  port           => 5432,
  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:

• pgpool
• pgpool::config
• pgpool::service
• pgpool::package
• pgpool::monitor
• pgpool::config::watchdog
• pgpool::config::pools
• pgpool::config::loadbalance
• pgpool::config::healthcheck
• pgpool::config::other
• pgpool::config::memorycache
• pgpool::config::ssl
• pgpool::config::logs
• pgpool::config::replication
• pgpool::config::masterslave
• pgpool::config::connection
• pgpool::config::heartbeat
• pgpool::config::service
• pgpool::config::failover

Resources:

• pgpool::pool_passwd
• pgpool::pcp
• pgpool::hba
• pgpool::config::backend
• pgpool::config::val
• pgpool::config::wdother

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.