salt.states.postgres_extension

Management of PostgreSQL extensions

A module used to install and manage PostgreSQL extensions.

adminpack:
  postgres_extension.present

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