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