New in version 2.8.
Parameter | Choices/Defaults | Comments |
---|---|---|
ca_cert
string
|
Specifies the name of a file containing SSL certificate authority (CA) certificate(s).
If the file exists, the server's certificate will be verified to be signed by one of these authorities.
aliases: ssl_rootcert |
|
db
string
|
Name of database to connect to and run queries against.
aliases: login_db |
|
location
path
|
Path to the tablespace directory in the file system.
Ensure that the location exists and has right privileges.
aliases: path |
|
login_host
string
|
Host running the database.
|
|
login_password
string
|
The password used to authenticate with.
|
|
login_unix_socket
string
|
Path to a Unix domain socket for local connections.
|
|
login_user
string
|
Default: "postgres"
|
The username used to authenticate with.
|
owner
string
|
Name of the role to set as an owner of the tablespace.
If this option is not specified, the tablespace owner is a role that creates the tablespace.
|
|
port
integer
|
Default: 5432
|
Database port to connect to.
aliases: login_port |
rename_to
-
|
New name of the tablespace.
The new name cannot begin with pg_, as such names are reserved for system tablespaces.
|
|
session_role
string
|
Switch to session_role after connecting. The specified session_role must be a role that the current login_user is a member of.
Permissions checking for SQL commands is carried out as though the session_role were the one that had logged in originally.
|
|
set
dictionary
|
Dict of tablespace options to set. Supported from PostgreSQL 9.0.
For more information see https://www.postgresql.org/docs/current/sql-createtablespace.html.
When reset is passed as an option's value, if the option was set previously, it will be removed https://www.postgresql.org/docs/current/sql-altertablespace.html.
|
|
ssl_mode
string
|
|
Determines whether or with what priority a secure SSL TCP/IP connection will be negotiated with the server.
See https://www.postgresql.org/docs/current/static/libpq-ssl.html for more information on the modes.
Default of
prefer matches libpq default. |
state
string
|
|
Tablespace state.
state=present implies the tablespace must be created if it doesn't exist.
state=absent implies the tablespace must be removed if present. state=absent is mutually exclusive with location, owner, i(set).
See the Notes section for information about check mode restrictions.
|
tablespace
string
/ required
|
Name of the tablespace to add or remove.
aliases: name |
Note
postgres
account on the host.postgresql
, libpq-dev
, and python-psycopg2
packages on the remote host before using this module.- name: Create a new tablespace called acme and set bob as an its owner
postgresql_tablespace:
name: acme
owner: bob
location: /data/foo
- name: Create a new tablespace called bar with tablespace options
postgresql_tablespace:
name: bar
set:
random_page_cost: 1
seq_page_cost: 1
- name: Reset random_page_cost option
postgresql_tablespace:
name: bar
set:
random_page_cost: reset
- name: Rename the tablespace from bar to pcie_ssd
postgresql_tablespace:
name: bar
rename_to: pcie_ssd
- name: Drop tablespace called bloat
postgresql_tablespace:
name: bloat
state: absent
Common return values are documented here, the following are the fields unique to this module:
Key | Returned | Description |
---|---|---|
location
string
|
always |
Path to the tablespace in the file system.
Sample:
/incredible/fast/ssd
|
newname
string
|
if existent |
New tablespace name
Sample:
new_ssd
|
options
dictionary
|
always |
Tablespace options.
Sample:
{'random_page_cost': 1, 'seq_page_cost': 1}
|
owner
string
|
always |
Tablespace owner.
Sample:
Bob
|
queries
string
|
always |
List of queries that was tried to be executed.
Sample:
["CREATE TABLESPACE bar LOCATION '/incredible/ssd'"]
|
state
string
|
always |
Tablespace state at the end of execution.
Sample:
present
|
tablespace
string
|
always |
Tablespace name.
Sample:
ssd
|
Hint
If you notice any issues in this documentation you can edit this document to improve it.