salt.states.postgres_tablespace

Management of PostgreSQL tablespace

A module used to create and manage PostgreSQL tablespaces.

ssd-tablespace:
  postgres_tablespace.present:
    - name: indexes
    - directory: /mnt/ssd-data

New in version 2015.8.0.

salt.states.postgres_tablespace.absent(name, user=None, maintenance_db=None, db_password=None, db_host=None, db_port=None, db_user=None)

Ensure that the named database is absent.

name
The name of the database to remove
db_user
database username if different from config or defaul
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
user
System user all operations should be performed on behalf of
salt.states.postgres_tablespace.present(name, directory, options=None, owner=None, user=None, maintenance_db=None, db_password=None, db_host=None, db_port=None, db_user=None)

Ensure that the named tablespace is present with the specified properties. For more information about all of these options see man create_tablespace(1).

name
The name of the tablespace to create/manage.
directory
The directory where the tablespace will be located, must already exist.
options
A dictionary of options to specify for the table. Currently, the only tablespace options supported are seq_page_cost - float; default=1.0 random_page_cost - float; default=4.0
owner
The database user that will be the owner of the tablespace Defaults to the user executing the command (i.e. the user option)
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
user
System user all operations should be performed on behalf of

Docs for previous releases are available on readthedocs.org.

Latest Salt release: 2016.3.2

Table Of Contents

Previous topic

salt.states.postgres_schema

Next topic

salt.states.postgres_user