mc_pgsql / Postgresql related functions

mc_states.modules.mc_pgsql.settings()

Postgresql settings registry

pgDbs

mapping of postgresql databases with their settings

postgresqlUsers

mapping of postgresql users with their settings

user

system user

version

default postgres version

defaultPgVersion

default postgres version

versions

activated postgresql version

postgis

mapping of supported postgres per postgis version

postgis_db

name of the postis template

pg_hba

List of pg_hba entries

pg_conf

settings for postgresql.conf ‘default’ is looked up by default but you can override settings for a specific version inside a subversion part eg:

makina-states.services.db.postgresql.pg_conf.9.1:
    port: 5433


listen
    list of hosts to listen on
port
    value for port
unix_socket_directories
    value for unix_socket_directories
extras
    free dict with key/values pairs,
    for strings you must quote them::

        makina-states.services.db.postgresql.pg_conf.extras:
          # no quote
          enable_tidscan: 'on'
          # quote
          log_line_prefix: "'%t '"

mc_states.modules.mc_pgsql.wrapper(wrappy)

Wrap a postgresql salt module function to set automaticly the socket or port to use. This is debian specific for now