main.yml in taperole-1.3.0

- old
+ new

@@ -93,10 +93,12 @@
   - 'DEFAULT'
   - '!LOW'
   - '!EXP'
   - '!MD5'
   - '@STRENGTH'
+postgresql_ssl_prefer_server_ciphers: on
+postgresql_ssl_ecdh_curve: 'prime256v1'
 postgresql_ssl_renegotiation_limit: 512MB # amount of data between renegotiations
 postgresql_ssl_cert_file: /etc/ssl/certs/ssl-cert-snakeoil.pem
 postgresql_ssl_key_file: /etc/ssl/private/ssl-cert-snakeoil.key
 postgresql_ssl_ca_file: ''
 postgresql_ssl_crl_file: ''
@@ -119,21 +121,30 @@
 #------------------------------------------------------------------------------
 
 # - Memory -
 
 postgresql_shared_buffers:       128MB # min 128kB
+postgresql_huge_pages:           try   # on, off, or try
 postgresql_temp_buffers:         8MB   # min 800kB
 
 # Note:  Increasing max_prepared_transactions costs ~600 bytes of shared memory
 # per transaction slot, plus lock space (see max_locks_per_transaction).
 # It is not advisable to set max_prepared_transactions nonzero unless you
 # actively intend to use prepared transactions.
 postgresql_max_prepared_transactions: 0 # zero disables the feature
 
 postgresql_work_mem:             1MB   # min 64kB
 postgresql_maintenance_work_mem: 16MB  # min 1MB
+postgresql_autovacuum_work_mem:  -1    # min 1MB, or -1 to use maintenance_work_mem
 postgresql_max_stack_depth:      2MB   # min 100kB
+postgresql_dynamic_shared_memory_type: posix    # the default is the first option
+                                                # supported by the operating system:
+                                                #   posix
+                                                #   sysv
+                                                #   windows
+                                                #   mmap
+                                                # use none to disable dynamic shared memory
 
 
 # - Disk -
 
 # limits per-session temp file space in kB, or -1 for no limit
@@ -163,19 +174,20 @@
 
 
 # - Asynchronous Behavior -
 
 postgresql_effective_io_concurrency: 1     # 1-1000; 0 disables prefetching
+postgresql_max_worker_processes: 8
 
 
 #------------------------------------------------------------------------------
 # WRITE AHEAD LOG
 #------------------------------------------------------------------------------
 
 # - Settings -
 
-postgresql_wal_level: minimal  # minimal, archive, or hot_standby
+postgresql_wal_level: minimal  # minimal, archive, hot_standby, or logical
 postgresql_fsync: on  # turns forced synchronization on or off
 
 # Synchronization level:
 # - off
 # - local
@@ -191,10 +203,11 @@
 # - open_sync
 postgresql_wal_sync_method: fsync
 
 # recover from partial page writes
 postgresql_full_page_writes: on
+postgresql_wal_log_hints: off       # also do full page writes of non-critical updates
 
 postgresql_wal_buffers:      -1     # min 32kB, -1 sets based on shared_buffers
 postgresql_wal_writer_delay: 200ms  # 1-10000 milliseconds
 postgresql_commit_delay:     0      # range 0-100000, in microseconds
 postgresql_commit_siblings:  5      # range 1-1000
@@ -234,10 +247,11 @@
 # max number of walsender processes
 postgresql_max_wal_senders: 0
 
 postgresql_wal_keep_segments:  0    # in logfile segments, 16MB each; 0 disables
 postgresql_wal_sender_timeout: 60s  # in milliseconds; 0 disables
+postgresql_max_replication_slots: 0 # max number of replication slots
 
 
 # - Master Server -
 
 # These settings are ignored on a standby server.
@@ -488,10 +502,12 @@
 postgresql_autovacuum_vacuum_scale_factor: 0.2
 # fraction of table size before analyze
 postgresql_autovacuum_analyze_scale_factor: 0.1
 # maximum XID age before forced vacuum
 postgresql_autovacuum_freeze_max_age: 200000000
+# maximum Multixact age before forced vacuum
+postgresql_autovacuum_multixact_freeze_max_age: 400000000
 # default vacuum cost delay for autovacuum, in milliseconds
 postgresql_autovacuum_vacuum_cost_delay: 20ms
 # default vacuum cost limit for autovacuum,
 postgresql_autovacuum_vacuum_cost_limit: -1
 
@@ -516,10 +532,12 @@
 
 postgresql_statement_timeout:       0  # in milliseconds, 0 is disabled
 postgresql_lock_timeout:            0  # in milliseconds, 0 is disabled
 postgresql_vacuum_freeze_min_age:   50000000
 postgresql_vacuum_freeze_table_age: 150000000
+postgresql_vacuum_multixact_freeze_min_age: 5000000
+postgresql_vacuum_multixact_freeze_table_age: 150000000
 
 postgresql_bytea_output: hex  # hex, escape
 postgresql_xmlbinary:    base64
 postgresql_xmloption:    content
 
@@ -555,10 +573,11 @@
 
 postgresql_default_text_search_config: pg_catalog.english
 
 postgresql_dynamic_library_path: '$libdir'
 postgresql_local_preload_libraries: []
+postgresql_session_preload_libraries: []
 
 
 #------------------------------------------------------------------------------
 # LOCK MANAGEMENT
 #------------------------------------------------------------------------------
@@ -602,15 +621,30 @@
 postgresql_exit_on_error: off
 # Reinitialize after backend crash?
 postgresql_restart_after_crash: on
 
 
+#------------------------------------------------------------------------------
+# PGTUNE
+#------------------------------------------------------------------------------
+# Should we run pgtune and accept the changes it proposes?
+postgresql_pgtune: no
+# Total system memory in bytes, will attempt to detect if set to "no"
+postgresql_pgtune_memory: no
+# Database type, valid options are DW, OLTP, Web, Mixed, Desktop
+postgresql_pgtune_type: Mixed
+# Maximum number of expected connections, if "no", default based on db type
+postgresql_pgtune_connections: no
 
 
+
+
 postgresql_env:
   LC_ALL: "{{ postgresql_locale }}"
   LC_LCTYPE: "{{ postgresql_locale }}"
 
 # APT settings
 postgresql_apt_key_id: ACCC4CF8
 postgresql_apt_key_url: "https://www.postgresql.org/media/keys/ACCC4CF8.asc"
 postgresql_apt_repository: 'deb http://apt.postgresql.org/pub/repos/apt/ {{ansible_distribution_release}}-pgdg main'
+# Pin-Priority of PGDG repository
+postgresql_apt_pin_priority: 500