salt.states.postgres_extension¶

Management of PostgreSQL extensions (e.g.: postgis)¶

The postgres_extensions module is used to create and manage Postgres extensions.

adminpack:
  postgres_extension.present

salt.states.postgres_extension.absent(name, if_exists=None, restrict=None, cascade=None, user=None, maintenance_db=None, db_password=None, db_host=None, db_port=None, db_user=None)¶

Ensure that the named extension is absent

name

Extension name of the extension to remove

cascade

Drop on cascade

if_exists

Add if exist slug

restrict

Add restrict slug

maintenance_db

Database to act on

user

System user all operations should be performed on behalf of

db_user

database username if different from config or default

db_password

user password if any password for a specified user

db_host

Database host if different from config or default

db_port

Database port if different from config or default

salt.states.postgres_extension.present(name, if_not_exists=None, schema=None, ext_version=None, from_version=None, user=None, maintenance_db=None, db_password=None, db_host=None, db_port=None, db_user=None)¶

Ensure that the named extension is present with the specified privileges

name

The name of the extension to manage

if_not_exists

Add a if_not_exists switch to the ddl statement

schema

Schema to install the extension into

from_version

Old extension version if already installed

ext_version

version to install

user

System user all operations should be performed on behalf of

maintenance_db

Database to act on

db_user

database username if different from config or default

db_password

user password if any password for a specified user

db_host

Database host if different from config or default

db_port

Database port if different from config or default