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)