Readme

Synopsis

PostgreSQL is a powerful modern open source SQL database server.

confdroid_postgresql is a Puppet module to automate installation, configuration and management of all aspects of PostgreSQL(standalone) for Puppet 8

WARNING

Attention: Never use this puppet module on systems which have been previously configured manually. It is impossible to predict how and what would have been configured, hence previous configurations outside the scope of this module may be overwritten! Automated configurations require a test environment to verify that the module suits the purpose intended by the user, as well as tune the parameters, before deploying into live production

Features

Installation

• install binaries
• initialize the database cluster

Configuration

• manage directory structure including file system permissions and selinux context
• manage service status

Optional:

• manage single line entries in pg_hba via define
• manage roles and databases via define (set $pl_manage_content to true)
• manage extensions (set pl_manage_extensionsto true)
• install and manage pg_bouncer (set pl_use_pg_bouncerto true)
• enable SL / TLS manage TLS certificates (set pl_ssl_enabledto true and populate content externally through variables)

Repo Documentation

See the full Puppet documentation including parameters in docs/index.html.

Dependencies

All dependencies must be included in the catalogue.

Deployment

• native Puppet deployment

via site.pp or nodes.pp

node 'example.example.net' {
  include confdroid_postgresql
}

• through Foreman:

In order to apply parameters through Foreman, confdroid_postgresql::params must be added to the host or host group in question.

See more details about class deployment on Confdroid.com.

SELINUX

All files and directories are configured with correct selinux context. If selinux is disabled, these contexts are ignored.

Known Problems

Support

• OS: Rocky 9
• Puppet 6 - 8

Tests

• Puppet Lint
  • excluded tests:
    • --no-variable_scope-check: not applicable as we are inheriting parameters from params class. the lint check does not distinguish between facts and inherited parameters.
• Puppet Parser
• ERB Template Parser
• Sonar Quality Gate

Contact Us

contact Us

Disclaimer

ConfDroid as entity is entirely independent from Puppet. We provide custom configuration modules, written for specific purposes and specific environments. The modules are tested and supported only as documented, and require testing in designated environments (i.e. lab or development environments) for parameter tuning etc. before deploying into production environments.