Forge Home

postgresplus

Installation and confgiuration of a Postgres Plus server with replication

10,375 downloads

9,289 latest version

3.1 quality score

We run a couple of automated
scans to help you access a
module's quality. Each module is
given a score based on how well
the author has formatted their
code and documentation and
modules are also checked for
malware using VirusTotal.

Please note, the information below
is for guidance only and neither of
these methods should be considered
an endorsement by Puppet.

Version information

  • 1.0.2 (latest)
  • 1.0.1
  • 1.0.0
released Mar 19th 2015
This version is compatible with:
  • Puppet Enterprise 3.2.x
  • Puppet 3.x
  • ,

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'jlcox-postgresplus', '1.0.2'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add jlcox-postgresplus
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install jlcox-postgresplus --version 1.0.2

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.

Download

Documentation

jlcox/postgresplus — version 1.0.2 Mar 19th 2015

postgresplus

This is the postgresplus module.

With this module you can install any version of PostgrePlus and configure its pg_hba.conf and postgresql.conf files

Install

To install the server using Hiera:

    "postgresplus::version" : "9.2.1.3",
    "postgresplus::superpassword" : "[Database super user password]",
    "postgresplus::webusername" : "[Email account with access to EnterpriseDB web site]",
    "postgresplus::webpassword" : "[Password for EnterpriseDB web site]",
    "postgresplus::key" : "[Product Key]",
    "postgresplus::url_base" : "[URL base location to use for downloading]",
    "postgresplus::port" : "[Port number to use Defaults to 5444]",
    "postgresplus::with_jre" : "[true/false for JRE install]"

Adding rules to pg_hba.conf

postgresplus::hba_config { 'allow replication access': description => "Open up postgresql for replication", type => 'host', database => 'replication', user => 'replicator', address => 'all', auth_method => 'trust' }

Adding or changing configuration in postgresql.conf

postgresplus::config_entry { '[configuration option]': value => '[value for setting]', }

Replication

The following is the bare minimum required to setup replication.

Master Server

class { 'postgresplus': replication => 'true', repl_mode => 'master', repl_target_address => 'all', } class {'postgresplus::replication' : } postgresplus::config_entry { 'checkpoint_segments': value => '24', } postgresplus::config_entry { 'max_wal_senders' : value => '5', } postgresplus::config_entry { 'hot_standby': value => 'on' } postgresplus::config_entry { 'wal_level': value => 'hot_standby' }

Slave Server

class { 'postgresplus': replication => 'true', repl_mode => 'target', } class {'postgresplus::replication' :}

License

Contact

Support

Please log tickets and issues at our github site(https://github.com/jlcox1970/postgresplus)