dubzland.postgresql.postgresql_server role – The main entrypoint for postgresql.postgresql_server

Note

This role is part of the dubzland.postgresql collection (version 1.2.0).

It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it use: ansible-galaxy collection install dubzland.postgresql.

To use it in a playbook, specify: dubzland.postgresql.postgresql_server.

Entry point main – The main entrypoint for postgresql.postgresql_server

Synopsis

  • Installs the PostgreSQL server packages.

  • Adds required PostgreSQL configuration.

Parameters

Parameter

Comments

postgresql_server_cluster_name

string / required

Sets the name of the cluster, which is included in the process title

postgresql_server_configuration_dir

path / required

Directory containing PostgreSQL configuration files

postgresql_server_data_dir

path / required

Directory containing PostgreSQL data files

postgresql_server_datestyle

string / required

Sets the display format for date and time values

postgresql_server_default_text_search_config

string / required

Sets default text search configuration

postgresql_server_dynamic_shared_memory_type

string / required

Selects the dynamic shared memory implementation used

Choices:

  • "posix"

  • "sysv"

  • "windows"

  • "mmap"

postgresql_server_include_dir

string / required

Directory of configuration files to include

postgresql_server_lc_messages

string / required

Sets the language in which messages are displayed

postgresql_server_lc_monetary

string / required

Sets the locale for formatting monetary amounts

postgresql_server_lc_numeric

string / required

Sets the locale for formatting numbers

postgresql_server_lc_time

string / required

Sets the locale for formatting date and time values

postgresql_server_listen_addresses

list / elements=string

IP addresses the PostgreSQL server should bind to

Default: ["localhost"]

postgresql_server_log_line_prefix

string / required

Controls information prefixed to each log line

postgresql_server_log_timezone

string / required

Sets the time zone to use in log messages

postgresql_server_max_connections

integer / required

Maximum number of connections the PostgreSQL server should allow

postgresql_server_max_wal_size

string / required

Sets the WAL size that triggers a checkpoint

postgresql_server_min_wal_size

string / required

Sets the minimum size to shrink the WAL to

postgresql_server_port

integer / required

Port number the PostgreSQL server should listen on

postgresql_server_root_configuration_dir

path

Root directory to contain all PostgreSQL configuration.

Default: "/etc/postgresql"

postgresql_server_root_data-dir

path

Root directory to contain all PostgreSQL data.

Default: "/var/lib/postgresql"

postgresql_server_shared_buffers

string / required

Sets the number of shared memory buffers used by the server

postgresql_server_ssl

boolean / required

Enable SSL connections

Choices:

  • false

  • true

postgresql_server_ssl_cert_file

path

Location of the SSL server certificate file

postgresql_server_ssl_key_file

path

Location of the SSL server private key file

postgresql_server_timezone

string / required

Sets the time zone for displaying and interpreting time stamps

postgresql_server_unix_socket_directories

list / elements=path / required

Sets the directories where Unix-domain sockets will be created

postgresql_server_version

integer / required

Version of PostgreSQL to install