salt.states.postgres_extension¶

Management of PostgreSQL extensions¶

A module used to install and manage PostgreSQL extensions.

adminpack:
  postgres_extension.present

New in version 2014.7.0.

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

Ensure that the named extension is absent.

name: Extension name of the extension to remove
if_exists: Add if exist slug
restrict: Add restrict slug
cascade: Drop on cascade
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

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

Ensure that the named extension is present.

Note

Before you can use the state to load an extension into a database, the extension's supporting files must be already installed.

For more information about all of these options see CREATE EXTENSION SQL command reference in the PostgreSQL documentation.

name: The name of the extension to be installed
if_not_exists: Add an IF NOT EXISTS parameter to the DDL statement
schema: Schema to install the extension into
ext_version: Version to install
from_version: Old extension version if already installed
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