postgresplus

Installation and confgiuration of a Postgres Plus server with replication
Jason Cox

Jason Cox

jlcox

9,049 downloads

8,104 latest version

3.1 quality score

Version information

  • 1.0.2 (latest)
  • 1.0.1
  • 1.0.0
released Jul 3rd 2019
This version is compatible with:
  • Puppet Enterprise 3.2.x
  • Puppet 3.x
  • RedHat
    ,
    CentOS

Start using this module

Documentation

jlcox/postgresplus — version 1.0.2 Jul 3rd 2019

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)