puppet-postgres

puppet-postgres copied to clipboard

Postgres Puppet module.

All bugs produced by Kris Buytaert (and now Kit Plummer too).

There are two variables that need to be set at the site.pp level: $postgres_password = "password" This sets the default password for the postgres user and database. and $postgres_version = "84" This sets the version of Postgres to be required.

Init the database before you start configuring files as once hba files etc exists in /var/lib/pgsql/data the initial database creation won't work anymore .

include postgres
postgres::initdb{ 'host': }
# Current postmaster.ops template has only listen address configurable,  this can offcourse be expanded as needed...
postgres::config{ 'host': listen => '*', }
postgres::hba { 'host':
  allowedrules => [
    'host    DATABASE all    10.0.0.0/32  trust',
  ],
}
postgres::enable{ 'host': }`

To add a user and password:

postgres::createuser{'username':passwd => 'password',}

To create a new database:

postgres::createdb{'newdb':owner=> 'username',}