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

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