salt.states.postgres_tablespace

Management of PostgreSQL tablespace

The postgres_tablespace module is used to create and manage Postgres tablespaces. Tablespaces can be set as either absent or present. .. code-block:: yaml

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

New in version Beryllium.

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 .. versionadded:: Beryllium
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

New in version Beryllium.