Installs and configures both PostgreSQL server and client with creation of various DB objects in the cluster.

Installs the PostgreSQL client binaries and libraries.

Creates such DB objects as: users, tablespaces, databases, schemas and extensions. See pillar.example file for details.

Installs the PostgreSQL adapter for Python.

Installs the PostgreSQL server package and prepares the DB cluster.

Configures the PostgreSQL Official (upstream) repository on target system if applicable.

The state relies on the postgres:use_upstream_repo Pillar value which could be set as following:

• True (default): adds the upstream repository to install packages from
• False: makes sure that the repository configuration is absent

The postgres:version Pillar controls which version of the PostgreSQL packages should be installed from the upstream repository. Defaults to 9.5.

Testing is done with the kitchen-salt.

Runs the postgres main state.

Runs serverspec tests on the actual instance.

Builds and runs tests from scratch.

Gives you ssh to the vagrant machine for manual testing.