API tools faq
paste
tnt4brain

default_db plugin table example

tnt4brain
Oct 10th, 2021
136
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 227.73 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE IF NOT EXISTS logs
  2. (
  3.     uuid uuid NOT NULL,
  4.     DATA jsonb,
  5.     TIMESTAMP TIMESTAMP WITH TIME zone,
  6.     id bigserial
  7.         CONSTRAINT logs_pk
  8.             PRIMARY KEY,
  9.     origin text
  10. );
  11.  
  12. ALTER TABLE logs owner TO ansible;
  13.  
  14. CREATE INDEX IF NOT EXISTS logs_uuid_index
  15.     ON logs (uuid);
  16.  
  17.  
  18. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"diff": false, "name": "all", "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000006", "vars": {}, "hosts": ["all"], "order": null, "roles": [], "tasks": [{"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}], "become": true, "no_log": null, "serial": [], "debugger": null, "handlers": [], "run_once": null, "squashed": false, "strategy": "linear", "throttle": 0, "fact_path": null, "finalized": true, "pre_tasks": [], "become_exe": null, "check_mode": false, "connection": "smart", "post_tasks": [], "vars_files": [], "become_user": "postgres", "collections": [], "environment": null, "remote_user": null, "vars_prompt": [], "become_flags": null, "gather_facts": false, "become_method": "sudo", "gather_subset": ["all"], "ignore_errors": null, "included_path": null, "force_handlers": false, "gather_timeout": 10, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null, "max_fail_percentage": null}', '2021-10-09 18:41:07.000000 +00:00', 1420, 'v2_playbook_on_play_start');
  19. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"name": "icinga2", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create database", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000008", "vars": {"telegram": "@tnt4brain", "created_by": "Sergey Pechenko"}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_db", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:07.000000 +00:00', 1421, 'v2_playbook_on_task_start');
  20. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"name": "icinga2", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create database", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000008", "vars": {"telegram": "@tnt4brain", "created_by": "Sergey Pechenko"}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_db", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:07.000000 +00:00', 1422, 'v2_runner_on_start');
  21. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"db": "icinga2", "changed": false, "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "name": "icinga2", "port": 5432, "owner": "", "state": "present", "target": "", "ca_cert": null, "encoding": "", "lc_ctype": "", "ssl_mode": "prefer", "template": "", "conn_limit": "", "lc_collate": "", "login_host": "", "login_user": "postgres", "tablespace": "", "target_opts": "", "session_role": null, "login_password": "", "maintenance_db": "postgres", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "_ansible_no_log": false}', '2021-10-09 18:41:08.000000 +00:00', 1423, 'v2_runner_on_ok');
  22. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "query": "{{ item }}", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": ["DROP FUNCTION IF EXISTS from_unixtime(bigint);", "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n", "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);", "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n", "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n"], "name": "Create functions (loop)", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000009", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_query", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": "items", "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:08.000000 +00:00', 1424, 'v2_playbook_on_task_start');
  23. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "query": "{{ item }}", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": ["DROP FUNCTION IF EXISTS from_unixtime(bigint);", "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n", "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);", "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n", "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n"], "name": "Create functions (loop)", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000009", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_query", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": "items", "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:08.000000 +00:00', 1425, 'v2_runner_on_start');
  24. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"item": "DROP FUNCTION IF EXISTS from_unixtime(bigint);", "query": "DROP FUNCTION IF EXISTS from_unixtime(bigint);", "changed": false, "rowcount": 0, "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "DROP FUNCTION IF EXISTS from_unixtime(bigint);", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "DROP FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "DROP FUNCTION IF EXISTS from_unixtime(bigint);"}', '2021-10-09 18:41:10.000000 +00:00', 1426, 'v2_runner_item_on_ok');
  25. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"item": "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n", "query": "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n", "changed": false, "rowcount": 0, "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "CREATE FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n"}', '2021-10-09 18:41:10.000000 +00:00', 1427, 'v2_runner_item_on_ok');
  26. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"item": "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);", "query": "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);", "changed": false, "rowcount": 0, "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "DROP FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);"}', '2021-10-09 18:41:11.000000 +00:00', 1428, 'v2_runner_item_on_ok');
  27. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"item": "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n", "query": "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n", "changed": false, "rowcount": 0, "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "CREATE FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n"}', '2021-10-09 18:41:12.000000 +00:00', 1429, 'v2_runner_item_on_ok');
  28. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"item": "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n", "query": "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n", "changed": false, "rowcount": 0, "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "CREATE FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n"}', '2021-10-09 18:41:12.000000 +00:00', 1430, 'v2_runner_item_on_ok');
  29. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"msg": "All items completed", "changed": false, "results": [{"item": "DROP FUNCTION IF EXISTS from_unixtime(bigint);", "query": "DROP FUNCTION IF EXISTS from_unixtime(bigint);", "failed": false, "changed": false, "rowcount": 0, "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "DROP FUNCTION IF EXISTS from_unixtime(bigint);", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "DROP FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "DROP FUNCTION IF EXISTS from_unixtime(bigint);"}, {"item": "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n", "query": "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n", "failed": false, "changed": false, "rowcount": 0, "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "CREATE FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "CREATE FUNCTION from_unixtime(bigint) RETURNS timestamp AS $$ SELECT to_timestamp($1) AT TIME ZONE ''UTC'' AS result $$ LANGUAGE sql;\n"}, {"item": "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);", "query": "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);", "failed": false, "changed": false, "rowcount": 0, "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "DROP FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "DROP FUNCTION IF EXISTS unix_timestamp(timestamp WITH TIME ZONE);"}, {"item": "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n", "query": "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n", "failed": false, "changed": false, "rowcount": 0, "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "CREATE FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "CREATE OR REPLACE FUNCTION unix_timestamp(timestamp) RETURNS bigint AS ''\n  SELECT CAST(EXTRACT(EPOCH FROM $1) AS bigint) AS result;\n'' LANGUAGE sql;\n"}, {"item": "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n", "query": "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n", "failed": false, "changed": false, "rowcount": 0, "invocation": {"module_args": {"db": "icinga2", "port": 5432, "query": "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n", "ca_cert": null, "ssl_mode": "prefer", "autocommit": false, "login_host": "", "login_user": "postgres", "named_args": null, "session_role": null, "login_password": "", "path_to_script": null, "positional_args": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "query_result": {}, "statusmessage": "CREATE FUNCTION", "_ansible_no_log": false, "ansible_loop_var": "item", "_ansible_item_label": "CREATE OR REPLACE FUNCTION updatedbversion(version_i TEXT) RETURNS void AS $$ BEGIN IF EXISTS( SELECT * FROM icinga_dbversion WHERE name=''idoutils'') THEN UPDATE icinga_dbversion SET version=version_i, modify_time=NOW() WHERE name=''idoutils''; ELSE INSERT INTO icinga_dbversion (dbversion_id, name, version, create_time, modify_time) VALUES (''1'', ''idoutils'', version_i, NOW(), NOW()); END IF; RETURN; END; $$ LANGUAGE plpgsql;\n"}], "warnings": ["Module did not set no_log for login_password", "Module did not set no_log for login_password", "Module did not set no_log for login_password", "Module did not set no_log for login_password", "Module did not set no_log for login_password"]}', '2021-10-09 18:41:12.000000 +00:00', 1431, 'v2_runner_on_ok');
  30. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"name": "icinga_acknowledgements", "columns": ["acknowledgement_id bigserial", "instance_id bigint default 0", "entry_time timestamp", "entry_time_usec INTEGER  default 0", "acknowledgement_type INTEGER  default 0", "object_id bigint default 0", "state INTEGER  default 0", "author_name TEXT  default ''''", "comment_data TEXT  default ''''", "is_sticky INTEGER  default 0", "persistent_comment INTEGER  default 0", "notify_contacts INTEGER  default 0", "end_time timestamp", "CONSTRAINT PK_acknowledgement_id PRIMARY KEY (acknowledgement_id)"], "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create table #1", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000a", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_table", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:12.000000 +00:00', 1432, 'v2_playbook_on_task_start');
  31. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"name": "icinga_acknowledgements", "columns": ["acknowledgement_id bigserial", "instance_id bigint default 0", "entry_time timestamp", "entry_time_usec INTEGER  default 0", "acknowledgement_type INTEGER  default 0", "object_id bigint default 0", "state INTEGER  default 0", "author_name TEXT  default ''''", "comment_data TEXT  default ''''", "is_sticky INTEGER  default 0", "persistent_comment INTEGER  default 0", "notify_contacts INTEGER  default 0", "end_time timestamp", "CONSTRAINT PK_acknowledgement_id PRIMARY KEY (acknowledgement_id)"], "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create table #1", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000a", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_table", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:12.000000 +00:00', 1433, 'v2_runner_on_start');
  32. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"owner": "postgres", "state": "present", "table": "icinga_acknowledgements", "changed": false, "queries": [], "warnings": ["Module did not set no_log for login_password", "Database name has not been passed, used default database to connect to."], "invocation": {"module_args": {"db": "", "like": null, "name": "icinga_acknowledgements", "port": 5432, "owner": null, "state": "present", "table": "icinga_acknowledgements", "rename": null, "ca_cert": null, "cascade": false, "columns": ["acknowledgement_id bigserial", "instance_id bigint default 0", "entry_time timestamp", "entry_time_usec INTEGER  default 0", "acknowledgement_type INTEGER  default 0", "object_id bigint default 0", "state INTEGER  default 0", "author_name TEXT  default ''''", "comment_data TEXT  default ''''", "is_sticky INTEGER  default 0", "persistent_comment INTEGER  default 0", "notify_contacts INTEGER  default 0", "end_time timestamp", "CONSTRAINT PK_acknowledgement_id PRIMARY KEY (acknowledgement_id)"], "ssl_mode": "prefer", "truncate": false, "unlogged": false, "including": null, "login_host": "", "login_user": "postgres", "tablespace": null, "session_role": null, "login_password": "", "storage_params": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "tablespace": "", "storage_params": [], "_ansible_no_log": false}', '2021-10-09 18:41:14.000000 +00:00', 1434, 'v2_runner_on_ok');
  33. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "name": "icinga_commands", "columns": ["command_id bigserial", "instance_id bigint default 0", "config_type INTEGER  default 0", "object_id bigint default 0", "command_line TEXT  default ''''", "config_hash varchar(64) DEFAULT NULL", "CONSTRAINT PK_command_id PRIMARY KEY (command_id)", "CONSTRAINT UQ_commands UNIQUE (instance_id,object_id,config_type)"], "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create table #2", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000b", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_table", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:14.000000 +00:00', 1435, 'v2_playbook_on_task_start');
  34. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "name": "icinga_commands", "columns": ["command_id bigserial", "instance_id bigint default 0", "config_type INTEGER  default 0", "object_id bigint default 0", "command_line TEXT  default ''''", "config_hash varchar(64) DEFAULT NULL", "CONSTRAINT PK_command_id PRIMARY KEY (command_id)", "CONSTRAINT UQ_commands UNIQUE (instance_id,object_id,config_type)"], "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create table #2", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000b", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_table", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:14.000000 +00:00', 1436, 'v2_runner_on_start');
  35. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"owner": "testuser", "state": "present", "table": "icinga_commands", "changed": false, "queries": [], "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "like": null, "name": "icinga_commands", "port": 5432, "owner": null, "state": "present", "table": "icinga_commands", "rename": null, "ca_cert": null, "cascade": false, "columns": ["command_id bigserial", "instance_id bigint default 0", "config_type INTEGER  default 0", "object_id bigint default 0", "command_line TEXT  default ''''", "config_hash varchar(64) DEFAULT NULL", "CONSTRAINT PK_command_id PRIMARY KEY (command_id)", "CONSTRAINT UQ_commands UNIQUE (instance_id,object_id,config_type)"], "ssl_mode": "prefer", "truncate": false, "unlogged": false, "including": null, "login_host": "", "login_user": "postgres", "tablespace": null, "session_role": null, "login_password": "", "storage_params": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "tablespace": "", "storage_params": [], "_ansible_no_log": false}', '2021-10-09 18:41:14.000000 +00:00', 1437, 'v2_runner_on_ok');
  36. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "name": "testuser", "priv": "ALL", "password": "THAT", "encrypted": true, "role_attr_flags": "superuser", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create user 1", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000c", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_user", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:14.000000 +00:00', 1438, 'v2_playbook_on_task_start');
  37. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "name": "testuser", "priv": "ALL", "password": "THAT", "encrypted": true, "role_attr_flags": "superuser", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create user 1", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000c", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_user", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:14.000000 +00:00', 1439, 'v2_runner_on_start');
  38. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"user": "testuser", "changed": false, "queries": ["SELECT rolname FROM pg_roles WHERE rolname=(%s)"], "warnings": ["Module did not set no_log for login_password", "Module did not set no_log for no_password_changes"], "invocation": {"module_args": {"db": "icinga2", "name": "testuser", "port": 5432, "priv": "ALL", "user": "testuser", "state": "present", "groups": null, "ca_cert": null, "expires": null, "password": "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER", "ssl_mode": "prefer", "encrypted": true, "conn_limit": null, "login_host": "", "login_user": "postgres", "fail_on_user": true, "session_role": null, "login_password": "", "role_attr_flags": "superuser", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432", "no_password_changes": false}}, "_ansible_no_log": false}', '2021-10-09 18:41:16.000000 +00:00', 1440, 'v2_runner_on_ok');
  39. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "name": "read_only", "priv": "ALL", "role_attr_flags": "NOLOGIN", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create group 1", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000d", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_user", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:16.000000 +00:00', 1441, 'v2_playbook_on_task_start');
  40. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "name": "read_only", "priv": "ALL", "role_attr_flags": "NOLOGIN", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create group 1", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000d", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_user", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:16.000000 +00:00', 1442, 'v2_runner_on_start');
  41. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"user": "read_only", "changed": false, "queries": ["SELECT rolname FROM pg_roles WHERE rolname=(%s)"], "warnings": ["Module did not set no_log for login_password", "Module did not set no_log for no_password_changes"], "invocation": {"module_args": {"db": "icinga2", "name": "read_only", "port": 5432, "priv": "ALL", "user": "read_only", "state": "present", "groups": null, "ca_cert": null, "expires": null, "password": null, "ssl_mode": "prefer", "encrypted": true, "conn_limit": null, "login_host": "", "login_user": "postgres", "fail_on_user": true, "session_role": null, "login_password": "", "role_attr_flags": "NOLOGIN", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432", "no_password_changes": false}}, "_ansible_no_log": false}', '2021-10-09 18:41:17.000000 +00:00', 1443, 'v2_runner_on_ok');
  42. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"name": "serial", "start": 101, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create sequence", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000e", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_sequence", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:17.000000 +00:00', 1444, 'v2_playbook_on_task_start');
  43. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"name": "serial", "start": 101, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create sequence", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000e", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_sequence", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:17.000000 +00:00', 1445, 'v2_runner_on_start');
  44. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"cycle": "NO", "owner": "postgres", "start": "101", "state": "present", "schema": "public", "changed": true, "queries": ["CREATE SEQUENCE \"public\".\"serial\" START WITH 101"], "maxvalue": "9223372036854775807", "minvalue": "1", "sequence": "serial", "warnings": ["Module did not set no_log for login_password", "Database name has not been passed, used default database to connect to."], "data_type": "bigint", "increment": "1", "invocation": {"module_args": {"db": "", "name": "serial", "port": 5432, "cache": null, "cycle": false, "owner": null, "start": 101, "state": "present", "schema": "public", "ca_cert": null, "cascade": false, "maxvalue": null, "minvalue": null, "sequence": "serial", "ssl_mode": "prefer", "data_type": null, "increment": null, "newschema": null, "rename_to": null, "login_host": "", "login_user": "postgres", "session_role": null, "login_password": "", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "_ansible_no_log": false}', '2021-10-09 18:41:18.000000 +00:00', 1446, 'v2_runner_on_ok');
  45. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"name": "serial", "start": 101, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create sequence #2", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000f", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_sequence", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:18.000000 +00:00', 1447, 'v2_playbook_on_task_start');
  46. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"name": "serial", "start": 101, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create sequence #2", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000000f", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_sequence", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:18.000000 +00:00', 1448, 'v2_runner_on_start');
  47. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"cycle": "NO", "owner": "postgres", "start": "101", "state": "present", "schema": "public", "changed": false, "queries": [], "maxvalue": "9223372036854775807", "minvalue": "1", "sequence": "serial", "warnings": ["Module did not set no_log for login_password", "Database name has not been passed, used default database to connect to."], "data_type": "bigint", "increment": "1", "invocation": {"module_args": {"db": "", "name": "serial", "port": 5432, "cache": null, "cycle": false, "owner": null, "start": 101, "state": "present", "schema": "public", "ca_cert": null, "cascade": false, "maxvalue": null, "minvalue": null, "sequence": "serial", "ssl_mode": "prefer", "data_type": null, "increment": null, "newschema": null, "rename_to": null, "login_host": "", "login_user": "postgres", "session_role": null, "login_password": "", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "_ansible_no_log": false}', '2021-10-09 18:41:19.000000 +00:00', 1449, 'v2_runner_on_ok');
  48. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"name": "serial", "state": "absent", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Delete sequence #2", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000010", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_sequence", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:19.000000 +00:00', 1450, 'v2_playbook_on_task_start');
  49. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"name": "serial", "state": "absent", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Delete sequence #2", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000010", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_sequence", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:19.000000 +00:00', 1451, 'v2_runner_on_start');
  50. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"cycle": "NO", "owner": "postgres", "start": "101", "state": "absent", "schema": "public", "changed": true, "queries": ["DROP SEQUENCE \"public\".\"serial\""], "maxvalue": "9223372036854775807", "minvalue": "1", "sequence": "serial", "warnings": ["Module did not set no_log for login_password", "Database name has not been passed, used default database to connect to."], "data_type": "bigint", "increment": "1", "invocation": {"module_args": {"db": "", "name": "serial", "port": 5432, "cache": null, "cycle": false, "owner": null, "start": null, "state": "absent", "schema": "public", "ca_cert": null, "cascade": false, "maxvalue": null, "minvalue": null, "sequence": "serial", "ssl_mode": "prefer", "data_type": null, "increment": null, "newschema": null, "rename_to": null, "login_host": "", "login_user": "postgres", "session_role": null, "login_password": "", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "_ansible_no_log": false}', '2021-10-09 18:41:20.000000 +00:00', 1452, 'v2_runner_on_ok');
  51. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"objs": "icinga_commands", "type": "table", "privs": "ALL", "roles": "testuser", "state": "present", "schema": "public", "database": "icinga2", "grant_option": false, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Grant privileges", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000011", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_privs", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:20.000000 +00:00', 1453, 'v2_playbook_on_task_start');
  52. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"objs": "icinga_commands", "type": "table", "privs": "ALL", "roles": "testuser", "state": "present", "schema": "public", "database": "icinga2", "grant_option": false, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Grant privileges", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000011", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_privs", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:20.000000 +00:00', 1454, 'v2_runner_on_start');
  53. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"changed": false, "queries": ["GRANT ALL ON table \"public\".\"icinga_commands\" TO \"testuser\";\nREVOKE GRANT OPTION FOR ALL ON table \"public\".\"icinga_commands\" FROM \"testuser\";"], "invocation": {"module_args": {"host": "", "objs": "icinga_commands", "port": 5432, "type": "table", "login": "postgres", "privs": "ALL", "roles": "testuser", "state": "present", "schema": "public", "ca_cert": null, "database": "icinga2", "password": "", "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "unix_socket": "/var/run/postgresql/.s.PGSQL.5432", "fail_on_role": true, "grant_option": false, "session_role": null, "target_roles": null, "login_password": "", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "_ansible_no_log": false}', '2021-10-09 18:41:21.000000 +00:00', 1455, 'v2_runner_on_ok');
  54. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "name": "synthezoid", "state": "present", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create schema", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000012", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_schema", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:21.000000 +00:00', 1456, 'v2_playbook_on_task_start');
  55. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "name": "synthezoid", "state": "present", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Create schema", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000012", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_schema", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:21.000000 +00:00', 1457, 'v2_runner_on_start');
  56. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"schema": "synthezoid", "changed": false, "queries": [], "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "name": "synthezoid", "port": 5432, "owner": "", "state": "present", "schema": "synthezoid", "ca_cert": null, "database": "icinga2", "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "cascade_drop": false, "session_role": null, "login_password": "", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "_ansible_no_log": false}', '2021-10-09 18:41:23.000000 +00:00', 1458, 'v2_runner_on_ok');
  57. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Pingy", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000013", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_ping", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:23.000000 +00:00', 1459, 'v2_playbook_on_task_start');
  58. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Pingy", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000013", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_ping", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:23.000000 +00:00', 1460, 'v2_runner_on_start');
  59. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"changed": false, "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": null, "port": 5432, "ca_cert": null, "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "login_password": "", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "is_available": true, "server_version": {"major": 12, "minor": 7}, "_ansible_no_log": false}', '2021-10-09 18:41:24.000000 +00:00', 1461, 'v2_runner_on_ok');
  60. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Info", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000014", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_info", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:24.000000 +00:00', 1462, 'v2_playbook_on_task_start');
  61. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Info", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000014", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_info", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:24.000000 +00:00', 1463, 'v2_runner_on_start');
  62. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"roles": {"ansible": {"canlogin": true, "member_of": [], "superuser": false, "valid_until": ""}, "postgres": {"canlogin": true, "member_of": [], "superuser": true, "valid_until": ""}, "testuser": {"canlogin": true, "member_of": ["read_only"], "superuser": true, "valid_until": ""}, "read_only": {"canlogin": false, "member_of": [], "superuser": false, "valid_until": ""}}, "changed": false, "version": {"major": 12, "minor": 7}, "settings": {"jit": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "ssl": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "geqo": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "port": {"unit": "", "context": "postmaster", "max_val": "65535", "min_val": "1", "setting": "5432", "vartype": "integer", "boot_val": "5432", "pretty_val": "5432", "sourcefile": "", "pending_restart": false}, "fsync": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "bonjour": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "lc_time": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "en_US.UTF-8", "vartype": "string", "boot_val": "C", "pretty_val": "en_US.UTF-8", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "TimeZone": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "Europe/Moscow", "vartype": "string", "boot_val": "GMT", "pretty_val": "Europe/Moscow", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "hba_file": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_hba.conf", "vartype": "string", "boot_val": "", "pretty_val": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_hba.conf", "sourcefile": "", "pending_restart": false}, "lc_ctype": {"unit": "", "context": "internal", "max_val": "", "min_val": "", "setting": "en_US.UTF-8", "vartype": "string", "boot_val": "C", "pretty_val": "en_US.UTF-8", "sourcefile": "", "pending_restart": false}, "work_mem": {"unit": "kB", "context": "user", "max_val": "2147483647", "min_val": "64", "setting": "4096", "vartype": "integer", "boot_val": "4096", "pretty_val": "4MB", "sourcefile": "", "val_in_bytes": 4194304, "pending_restart": false}, "DateStyle": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "ISO, MDY", "vartype": "string", "boot_val": "ISO, MDY", "pretty_val": "ISO, MDY", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "geqo_seed": {"unit": "", "context": "user", "max_val": "1", "min_val": "0", "setting": "0", "vartype": "real", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "wal_level": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "replica", "vartype": "enum", "boot_val": "replica", "pretty_val": "replica", "sourcefile": "", "pending_restart": false}, "xmlbinary": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "base64", "vartype": "enum", "boot_val": "base64", "pretty_val": "base64", "sourcefile": "", "pending_restart": false}, "xmloption": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "content", "vartype": "enum", "boot_val": "content", "pretty_val": "content", "sourcefile": "", "pending_restart": false}, "autovacuum": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "block_size": {"unit": "", "context": "internal", "max_val": "8192", "min_val": "8192", "setting": "8192", "vartype": "integer", "boot_val": "8192", "pretty_val": "8192", "sourcefile": "", "pending_restart": false}, "huge_pages": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "try", "vartype": "enum", "boot_val": "try", "pretty_val": "try", "sourcefile": "", "pending_restart": false}, "ident_file": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_ident.conf", "vartype": "string", "boot_val": "", "pretty_val": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_ident.conf", "sourcefile": "", "pending_restart": false}, "lc_collate": {"unit": "", "context": "internal", "max_val": "", "min_val": "", "setting": "en_US.UTF-8", "vartype": "string", "boot_val": "C", "pretty_val": "en_US.UTF-8", "sourcefile": "", "pending_restart": false}, "lc_numeric": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "en_US.UTF-8", "vartype": "string", "boot_val": "C", "pretty_val": "en_US.UTF-8", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "trace_sort": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "array_nulls": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "config_file": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "vartype": "string", "boot_val": "", "pretty_val": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "sourcefile": "", "pending_restart": false}, "enable_sort": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "geqo_effort": {"unit": "", "context": "user", "max_val": "10", "min_val": "1", "setting": "5", "vartype": "integer", "boot_val": "5", "pretty_val": "5", "sourcefile": "", "pending_restart": false}, "hot_standby": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "lc_messages": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "en_US.UTF-8", "vartype": "string", "boot_val": "", "pretty_val": "en_US.UTF-8", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "lc_monetary": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "en_US.UTF-8", "vartype": "string", "boot_val": "C", "pretty_val": "en_US.UTF-8", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "search_path": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "\"$user\", public", "vartype": "string", "boot_val": "\"$user\", public", "pretty_val": "\"$user\", public", "sourcefile": "", "pending_restart": false}, "ssl_ca_file": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "ssl_ciphers": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "HIGH:MEDIUM:+3DES:!aNULL", "vartype": "string", "boot_val": "HIGH:MEDIUM:+3DES:!aNULL", "pretty_val": "HIGH:MEDIUM:+3DES:!aNULL", "sourcefile": "", "pending_restart": false}, "ssl_library": {"unit": "", "context": "internal", "max_val": "", "min_val": "", "setting": "OpenSSL", "vartype": "string", "boot_val": "OpenSSL", "pretty_val": "OpenSSL", "sourcefile": "", "pending_restart": false}, "wal_buffers": {"unit": "8kB", "context": "postmaster", "max_val": "262143", "min_val": "-1", "setting": "512", "vartype": "integer", "boot_val": "-1", "pretty_val": "4MB", "sourcefile": "", "val_in_bytes": 4194304, "pending_restart": false}, "wal_recycle": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "archive_mode": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "off", "vartype": "enum", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "bonjour_name": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "bytea_output": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "hex", "vartype": "enum", "boot_val": "hex", "pretty_val": "hex", "sourcefile": "", "pending_restart": false}, "cluster_name": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "commit_delay": {"unit": "", "context": "superuser", "max_val": "100000", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "event_source": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "PostgreSQL", "vartype": "string", "boot_val": "PostgreSQL", "pretty_val": "PostgreSQL", "sourcefile": "", "pending_restart": false}, "jit_provider": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "llvmjit", "vartype": "string", "boot_val": "llvmjit", "pretty_val": "llvmjit", "sourcefile": "", "pending_restart": false}, "lock_timeout": {"unit": "ms", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "log_duration": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_filename": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "postgresql-%a.log", "vartype": "string", "boot_val": "postgresql-%Y-%m-%d_%H%M%S.log", "pretty_val": "postgresql-%a.log", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "log_hostname": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_timezone": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "Europe/Moscow", "vartype": "string", "boot_val": "GMT", "pretty_val": "Europe/Moscow", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "max_wal_size": {"unit": "MB", "context": "sighup", "max_val": "2147483647", "min_val": "2", "setting": "1024", "vartype": "integer", "boot_val": "1024", "pretty_val": "1GB", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "val_in_bytes": 1073741824, "pending_restart": false}, "min_wal_size": {"unit": "MB", "context": "sighup", "max_val": "2147483647", "min_val": "2", "setting": "80", "vartype": "integer", "boot_val": "80", "pretty_val": "80MB", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "val_in_bytes": 83886080, "pending_restart": false}, "row_security": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "segment_size": {"unit": "8kB", "context": "internal", "max_val": "131072", "min_val": "131072", "setting": "131072", "vartype": "integer", "boot_val": "131072", "pretty_val": "1GB", "sourcefile": "", "val_in_bytes": 1073741824, "pending_restart": false}, "ssl_crl_file": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "ssl_key_file": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "server.key", "vartype": "string", "boot_val": "server.key", "pretty_val": "server.key", "sourcefile": "", "pending_restart": false}, "syslog_ident": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "postgres", "vartype": "string", "boot_val": "postgres", "pretty_val": "postgres", "sourcefile": "", "pending_restart": false}, "temp_buffers": {"unit": "8kB", "context": "user", "max_val": "1073741823", "min_val": "100", "setting": "1024", "vartype": "integer", "boot_val": "1024", "pretty_val": "8MB", "sourcefile": "", "val_in_bytes": 8388608, "pending_restart": false}, "trace_notify": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "track_counts": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "IntervalStyle": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "postgres", "vartype": "enum", "boot_val": "postgres", "pretty_val": "postgres", "sourcefile": "", "pending_restart": false}, "exit_on_error": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_directory": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "log", "vartype": "string", "boot_val": "log", "pretty_val": "log", "sourcefile": "", "pending_restart": false}, "log_file_mode": {"unit": "", "context": "sighup", "max_val": "511", "min_val": "0", "setting": "0600", "vartype": "integer", "boot_val": "384", "pretty_val": "0600", "sourcefile": "", "pending_restart": false}, "log_statement": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "all", "vartype": "enum", "boot_val": "none", "pretty_val": "all", "sourcefile": "", "pending_restart": false}, "seq_page_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "0", "setting": "1", "vartype": "real", "boot_val": "1", "pretty_val": "1", "sourcefile": "", "pending_restart": false}, "ssl_cert_file": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "server.crt", "vartype": "string", "boot_val": "server.crt", "pretty_val": "server.crt", "sourcefile": "", "pending_restart": false}, "wal_init_zero": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "wal_log_hints": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "bgwriter_delay": {"unit": "ms", "context": "sighup", "max_val": "10000", "min_val": "10", "setting": "200", "vartype": "integer", "boot_val": "200", "pretty_val": "200ms", "sourcefile": "", "pending_restart": false}, "cpu_tuple_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "0", "setting": "0.01", "vartype": "real", "boot_val": "0.01", "pretty_val": "0.01", "sourcefile": "", "pending_restart": false}, "data_checksums": {"unit": "", "context": "internal", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "data_directory": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "/var/opt/rh/rh-postgresql12/lib/pgsql/data", "vartype": "string", "boot_val": "", "pretty_val": "/var/opt/rh/rh-postgresql12/lib/pgsql/data", "sourcefile": "", "pending_restart": false}, "enable_hashagg": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "enable_seqscan": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "enable_tidscan": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "geqo_pool_size": {"unit": "", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "geqo_threshold": {"unit": "", "context": "user", "max_val": "2147483647", "min_val": "2", "setting": "12", "vartype": "integer", "boot_val": "12", "pretty_val": "12", "sourcefile": "", "pending_restart": false}, "jit_above_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "-1", "setting": "100000", "vartype": "real", "boot_val": "100000", "pretty_val": "100000", "sourcefile": "", "pending_restart": false}, "log_lock_waits": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_temp_files": {"unit": "kB", "context": "superuser", "max_val": "2147483647", "min_val": "-1", "setting": "-1", "vartype": "integer", "boot_val": "-1", "pretty_val": "-1", "sourcefile": "", "val_in_bytes": 0, "pending_restart": false}, "max_index_keys": {"unit": "", "context": "internal", "max_val": "32", "min_val": "32", "setting": "32", "vartype": "integer", "boot_val": "32", "pretty_val": "32", "sourcefile": "", "pending_restart": false}, "pre_auth_delay": {"unit": "s", "context": "sighup", "max_val": "60", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "server_version": {"unit": "", "context": "internal", "max_val": "", "min_val": "", "setting": "12.7", "vartype": "string", "boot_val": "12.7", "pretty_val": "12.7", "sourcefile": "", "pending_restart": false}, "shared_buffers": {"unit": "8kB", "context": "postmaster", "max_val": "1073741823", "min_val": "16", "setting": "16384", "vartype": "integer", "boot_val": "1024", "pretty_val": "128MB", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "val_in_bytes": 134217728, "pending_restart": false}, "ssl_ecdh_curve": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "prime256v1", "vartype": "string", "boot_val": "prime256v1", "pretty_val": "prime256v1", "sourcefile": "", "pending_restart": false}, "wal_block_size": {"unit": "", "context": "internal", "max_val": "8192", "min_val": "8192", "setting": "8192", "vartype": "integer", "boot_val": "8192", "pretty_val": "8192", "sourcefile": "", "pending_restart": false}, "archive_command": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "(disabled)", "vartype": "string", "boot_val": "", "pretty_val": "(disabled)", "sourcefile": "", "pending_restart": false}, "archive_timeout": {"unit": "s", "context": "sighup", "max_val": "1073741823", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "backslash_quote": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "safe_encoding", "vartype": "enum", "boot_val": "safe_encoding", "pretty_val": "safe_encoding", "sourcefile": "", "pending_restart": false}, "client_encoding": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "UTF8", "vartype": "string", "boot_val": "SQL_ASCII", "pretty_val": "UTF8", "sourcefile": "", "pending_restart": false}, "commit_siblings": {"unit": "", "context": "user", "max_val": "1000", "min_val": "0", "setting": "5", "vartype": "integer", "boot_val": "5", "pretty_val": "5", "sourcefile": "", "pending_restart": false}, "data_sync_retry": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "enable_hashjoin": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "enable_material": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "enable_nestloop": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "jit_expressions": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "log_checkpoints": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_connections": {"unit": "", "context": "superuser-backend", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_destination": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "stderr", "vartype": "string", "boot_val": "stderr", "pretty_val": "stderr", "sourcefile": "", "pending_restart": false}, "log_line_prefix": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "%m [%p] ", "vartype": "string", "boot_val": "%m [%p] ", "pretty_val": "%m [%p] ", "sourcefile": "", "pending_restart": false}, "max_connections": {"unit": "", "context": "postmaster", "max_val": "262143", "min_val": "1", "setting": "100", "vartype": "integer", "boot_val": "100", "pretty_val": "100", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "max_stack_depth": {"unit": "kB", "context": "superuser", "max_val": "2147483647", "min_val": "100", "setting": "2048", "vartype": "integer", "boot_val": "100", "pretty_val": "2MB", "sourcefile": "", "val_in_bytes": 2097152, "pending_restart": false}, "max_wal_senders": {"unit": "", "context": "postmaster", "max_val": "262143", "min_val": "0", "setting": "10", "vartype": "integer", "boot_val": "10", "pretty_val": "10", "sourcefile": "", "pending_restart": false}, "plan_cache_mode": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "auto", "vartype": "enum", "boot_val": "auto", "pretty_val": "auto", "sourcefile": "", "pending_restart": false}, "post_auth_delay": {"unit": "s", "context": "backend", "max_val": "2147", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "recovery_target": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "restore_command": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "server_encoding": {"unit": "", "context": "internal", "max_val": "", "min_val": "", "setting": "UTF8", "vartype": "string", "boot_val": "SQL_ASCII", "pretty_val": "UTF8", "sourcefile": "", "pending_restart": false}, "syslog_facility": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "local0", "vartype": "enum", "boot_val": "local0", "pretty_val": "local0", "sourcefile": "", "pending_restart": false}, "temp_file_limit": {"unit": "kB", "context": "superuser", "max_val": "2147483647", "min_val": "-1", "setting": "-1", "vartype": "integer", "boot_val": "-1", "pretty_val": "-1", "sourcefile": "", "val_in_bytes": 0, "pending_restart": false}, "track_functions": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "none", "vartype": "enum", "boot_val": "none", "pretty_val": "none", "sourcefile": "", "pending_restart": false}, "track_io_timing": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "wal_compression": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "wal_sync_method": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "fdatasync", "vartype": "enum", "boot_val": "fdatasync", "pretty_val": "fdatasync", "sourcefile": "", "pending_restart": false}, "application_name": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "deadlock_timeout": {"unit": "ms", "context": "superuser", "max_val": "2147483647", "min_val": "1", "setting": "1000", "vartype": "integer", "boot_val": "1000", "pretty_val": "1s", "sourcefile": "", "pending_restart": false}, "debug_assertions": {"unit": "", "context": "internal", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "debug_print_plan": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "enable_indexscan": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "enable_mergejoin": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "full_page_writes": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "geqo_generations": {"unit": "", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "jit_dump_bitcode": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "listen_addresses": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "localhost", "vartype": "string", "boot_val": "localhost", "pretty_val": "localhost", "sourcefile": "", "pending_restart": false}, "log_min_messages": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "warning", "vartype": "enum", "boot_val": "warning", "pretty_val": "warning", "sourcefile": "", "pending_restart": false}, "log_parser_stats": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_rotation_age": {"unit": "min", "context": "sighup", "max_val": "35791394", "min_val": "0", "setting": "1440", "vartype": "integer", "boot_val": "1440", "pretty_val": "1d", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "primary_conninfo": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "random_page_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "0", "setting": "4", "vartype": "real", "boot_val": "4", "pretty_val": "4", "sourcefile": "", "pending_restart": false}, "tcp_user_timeout": {"unit": "ms", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "temp_tablespaces": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "track_activities": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "wal_segment_size": {"unit": "B", "context": "internal", "max_val": "1073741824", "min_val": "1048576", "setting": "16777216", "vartype": "integer", "boot_val": "16777216", "pretty_val": "16MB", "sourcefile": "", "pending_restart": false}, "wal_writer_delay": {"unit": "ms", "context": "sighup", "max_val": "10000", "min_val": "1", "setting": "200", "vartype": "integer", "boot_val": "200", "pretty_val": "200ms", "sourcefile": "", "pending_restart": false}, "cpu_operator_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "0", "setting": "0.0025", "vartype": "real", "boot_val": "0.0025", "pretty_val": "0.0025", "sourcefile": "", "pending_restart": false}, "db_user_namespace": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "debug_print_parse": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "enable_bitmapscan": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "external_pid_file": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "integer_datetimes": {"unit": "", "context": "internal", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "krb_caseins_users": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_planner_stats": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_rotation_size": {"unit": "kB", "context": "sighup", "max_val": "2097151", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "10240", "pretty_val": "0", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "val_in_bytes": 0, "pending_restart": false}, "logging_collector": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "off", "pretty_val": "on", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "max_function_args": {"unit": "", "context": "internal", "max_val": "100", "min_val": "100", "setting": "100", "vartype": "integer", "boot_val": "100", "pretty_val": "100", "sourcefile": "", "pending_restart": false}, "primary_slot_name": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "statement_timeout": {"unit": "ms", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "unix_socket_group": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "vacuum_cost_delay": {"unit": "ms", "context": "user", "max_val": "100", "min_val": "0", "setting": "0", "vartype": "real", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "vacuum_cost_limit": {"unit": "", "context": "user", "max_val": "10000", "min_val": "1", "setting": "200", "vartype": "integer", "boot_val": "200", "pretty_val": "200", "sourcefile": "", "pending_restart": false}, "wal_keep_segments": {"unit": "", "context": "sighup", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "autovacuum_naptime": {"unit": "s", "context": "sighup", "max_val": "2147483", "min_val": "1", "setting": "60", "vartype": "integer", "boot_val": "60", "pretty_val": "1min", "sourcefile": "", "pending_restart": false}, "checkpoint_timeout": {"unit": "s", "context": "sighup", "max_val": "86400", "min_val": "30", "setting": "300", "vartype": "integer", "boot_val": "300", "pretty_val": "5min", "sourcefile": "", "pending_restart": false}, "checkpoint_warning": {"unit": "s", "context": "sighup", "max_val": "2147483647", "min_val": "0", "setting": "30", "vartype": "integer", "boot_val": "30", "pretty_val": "30s", "sourcefile": "", "pending_restart": false}, "debug_pretty_print": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "default_tablespace": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "enable_gathermerge": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "extra_float_digits": {"unit": "", "context": "user", "max_val": "3", "min_val": "-15", "setting": "1", "vartype": "integer", "boot_val": "1", "pretty_val": "1", "sourcefile": "", "pending_restart": false}, "krb_server_keyfile": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "FILE:/etc/opt/rh/rh-postgresql12/krb5.keytab", "vartype": "string", "boot_val": "FILE:/etc/opt/rh/rh-postgresql12/krb5.keytab", "pretty_val": "FILE:/etc/opt/rh/rh-postgresql12/krb5.keytab", "sourcefile": "", "pending_restart": false}, "log_disconnections": {"unit": "", "context": "superuser-backend", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_executor_stats": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "server_version_num": {"unit": "", "context": "internal", "max_val": "120007", "min_val": "120007", "setting": "120007", "vartype": "integer", "boot_val": "120007", "pretty_val": "120007", "sourcefile": "", "pending_restart": false}, "shared_memory_type": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "mmap", "vartype": "enum", "boot_val": "mmap", "pretty_val": "mmap", "sourcefile": "", "pending_restart": false}, "ssl_dh_params_file": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "synchronous_commit": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "enum", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "wal_sender_timeout": {"unit": "ms", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "60000", "vartype": "integer", "boot_val": "60000", "pretty_val": "1min", "sourcefile": "", "pending_restart": false}, "zero_damaged_pages": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "autovacuum_work_mem": {"unit": "kB", "context": "sighup", "max_val": "2147483647", "min_val": "-1", "setting": "-1", "vartype": "integer", "boot_val": "-1", "pretty_val": "-1", "sourcefile": "", "val_in_bytes": 0, "pending_restart": false}, "backend_flush_after": {"unit": "8kB", "context": "user", "max_val": "256", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "val_in_bytes": 0, "pending_restart": false}, "client_min_messages": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "notice", "vartype": "enum", "boot_val": "notice", "pretty_val": "notice", "sourcefile": "", "pending_restart": false}, "data_directory_mode": {"unit": "", "context": "internal", "max_val": "511", "min_val": "0", "setting": "0700", "vartype": "integer", "boot_val": "448", "pretty_val": "0700", "sourcefile": "", "pending_restart": false}, "force_parallel_mode": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "enum", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "from_collapse_limit": {"unit": "", "context": "user", "max_val": "2147483647", "min_val": "1", "setting": "8", "vartype": "integer", "boot_val": "8", "pretty_val": "8", "sourcefile": "", "pending_restart": false}, "geqo_selection_bias": {"unit": "", "context": "user", "max_val": "2", "min_val": "1.5", "setting": "2", "vartype": "real", "boot_val": "2", "pretty_val": "2", "sourcefile": "", "pending_restart": false}, "jit_tuple_deforming": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "join_collapse_limit": {"unit": "", "context": "user", "max_val": "2147483647", "min_val": "1", "setting": "8", "vartype": "integer", "boot_val": "8", "pretty_val": "8", "sourcefile": "", "pending_restart": false}, "log_error_verbosity": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "default", "vartype": "enum", "boot_val": "default", "pretty_val": "default", "sourcefile": "", "pending_restart": false}, "log_statement_stats": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "parallel_setup_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "0", "setting": "1000", "vartype": "real", "boot_val": "1000", "pretty_val": "1000", "sourcefile": "", "pending_restart": false}, "parallel_tuple_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "0", "setting": "0.1", "vartype": "real", "boot_val": "0.1", "pretty_val": "0.1", "sourcefile": "", "pending_restart": false}, "password_encryption": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "md5", "vartype": "enum", "boot_val": "md5", "pretty_val": "md5", "sourcefile": "", "pending_restart": false}, "recovery_target_lsn": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "recovery_target_xid": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "restart_after_crash": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "tcp_keepalives_idle": {"unit": "s", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "bgwriter_flush_after": {"unit": "8kB", "context": "sighup", "max_val": "256", "min_val": "0", "setting": "64", "vartype": "integer", "boot_val": "64", "pretty_val": "512kB", "sourcefile": "", "val_in_bytes": 524288, "pending_restart": false}, "constraint_exclusion": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "partition", "vartype": "enum", "boot_val": "partition", "pretty_val": "partition", "sourcefile": "", "pending_restart": false}, "cpu_index_tuple_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "0", "setting": "0.005", "vartype": "real", "boot_val": "0.005", "pretty_val": "0.005", "sourcefile": "", "pending_restart": false}, "dynamic_library_path": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "$libdir", "vartype": "string", "boot_val": "$libdir", "pretty_val": "$libdir", "sourcefile": "", "pending_restart": false}, "effective_cache_size": {"unit": "8kB", "context": "user", "max_val": "2147483647", "min_val": "1", "setting": "524288", "vartype": "integer", "boot_val": "524288", "pretty_val": "4GB", "sourcefile": "", "val_in_bytes": 4294967296, "pending_restart": false}, "enable_indexonlyscan": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "enable_parallel_hash": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "hot_standby_feedback": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "lo_compat_privileges": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "maintenance_work_mem": {"unit": "kB", "context": "user", "max_val": "2147483647", "min_val": "1024", "setting": "65536", "vartype": "integer", "boot_val": "65536", "pretty_val": "64MB", "sourcefile": "", "val_in_bytes": 67108864, "pending_restart": false}, "max_parallel_workers": {"unit": "", "context": "user", "max_val": "1024", "min_val": "0", "setting": "8", "vartype": "integer", "boot_val": "8", "pretty_val": "8", "sourcefile": "", "pending_restart": false}, "max_worker_processes": {"unit": "", "context": "postmaster", "max_val": "262143", "min_val": "0", "setting": "8", "vartype": "integer", "boot_val": "8", "pretty_val": "8", "sourcefile": "", "pending_restart": false}, "promote_trigger_file": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "recovery_end_command": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "recovery_target_name": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "recovery_target_time": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "stats_temp_directory": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "pg_stat_tmp", "vartype": "string", "boot_val": "pg_stat_tmp", "pretty_val": "pg_stat_tmp", "sourcefile": "", "pending_restart": false}, "synchronize_seqscans": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "tcp_keepalives_count": {"unit": "", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "update_process_title": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "vacuum_cost_page_hit": {"unit": "", "context": "user", "max_val": "10000", "min_val": "0", "setting": "1", "vartype": "integer", "boot_val": "1", "pretty_val": "1", "sourcefile": "", "pending_restart": false}, "wal_receiver_timeout": {"unit": "ms", "context": "sighup", "max_val": "2147483647", "min_val": "0", "setting": "60000", "vartype": "integer", "boot_val": "60000", "pretty_val": "1min", "sourcefile": "", "pending_restart": false}, "bgwriter_lru_maxpages": {"unit": "", "context": "sighup", "max_val": "1073741823", "min_val": "0", "setting": "100", "vartype": "integer", "boot_val": "100", "pretty_val": "100", "sourcefile": "", "pending_restart": false}, "check_function_bodies": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "cursor_tuple_fraction": {"unit": "", "context": "user", "max_val": "1", "min_val": "0", "setting": "0.1", "vartype": "real", "boot_val": "0.1", "pretty_val": "0.1", "sourcefile": "", "pending_restart": false}, "debug_print_rewritten": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "escape_string_warning": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "ignore_system_indexes": {"unit": "", "context": "backend", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "jit_debugging_support": {"unit": "", "context": "superuser-backend", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "jit_inline_above_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "-1", "setting": "500000", "vartype": "real", "boot_val": "500000", "pretty_val": "500000", "sourcefile": "", "pending_restart": false}, "jit_profiling_support": {"unit": "", "context": "superuser-backend", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "max_files_per_process": {"unit": "", "context": "postmaster", "max_val": "2147483647", "min_val": "25", "setting": "1000", "vartype": "integer", "boot_val": "1000", "pretty_val": "1000", "sourcefile": "", "pending_restart": false}, "max_identifier_length": {"unit": "", "context": "internal", "max_val": "63", "min_val": "63", "setting": "63", "vartype": "integer", "boot_val": "63", "pretty_val": "63", "sourcefile": "", "pending_restart": false}, "max_replication_slots": {"unit": "", "context": "postmaster", "max_val": "262143", "min_val": "0", "setting": "10", "vartype": "integer", "boot_val": "10", "pretty_val": "10", "sourcefile": "", "pending_restart": false}, "quote_all_identifiers": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "syslog_split_messages": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "transaction_isolation": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "read committed", "vartype": "enum", "boot_val": "read committed", "pretty_val": "read committed", "sourcefile": "", "pending_restart": false}, "transaction_read_only": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "transform_null_equals": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "vacuum_cost_page_miss": {"unit": "", "context": "user", "max_val": "10000", "min_val": "0", "setting": "10", "vartype": "integer", "boot_val": "10", "pretty_val": "10", "sourcefile": "", "pending_restart": false}, "vacuum_freeze_min_age": {"unit": "", "context": "user", "max_val": "1000000000", "min_val": "0", "setting": "50000000", "vartype": "integer", "boot_val": "50000000", "pretty_val": "50000000", "sourcefile": "", "pending_restart": false}, "authentication_timeout": {"unit": "s", "context": "sighup", "max_val": "600", "min_val": "1", "setting": "60", "vartype": "integer", "boot_val": "60", "pretty_val": "1min", "sourcefile": "", "pending_restart": false}, "autovacuum_max_workers": {"unit": "", "context": "postmaster", "max_val": "262143", "min_val": "1", "setting": "3", "vartype": "integer", "boot_val": "3", "pretty_val": "3", "sourcefile": "", "pending_restart": false}, "checkpoint_flush_after": {"unit": "8kB", "context": "sighup", "max_val": "256", "min_val": "0", "setting": "32", "vartype": "integer", "boot_val": "32", "pretty_val": "256kB", "sourcefile": "", "val_in_bytes": 262144, "pending_restart": false}, "enable_parallel_append": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "gin_fuzzy_search_limit": {"unit": "", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "gin_pending_list_limit": {"unit": "kB", "context": "user", "max_val": "2147483647", "min_val": "64", "setting": "4096", "vartype": "integer", "boot_val": "4096", "pretty_val": "4MB", "sourcefile": "", "val_in_bytes": 4194304, "pending_restart": false}, "old_snapshot_threshold": {"unit": "min", "context": "postmaster", "max_val": "86400", "min_val": "-1", "setting": "-1", "vartype": "integer", "boot_val": "-1", "pretty_val": "-1", "sourcefile": "", "pending_restart": false}, "recovery_target_action": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "pause", "vartype": "enum", "boot_val": "pause", "pretty_val": "pause", "sourcefile": "", "pending_restart": false}, "ssl_passphrase_command": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "timezone_abbreviations": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "Default", "vartype": "string", "boot_val": "", "pretty_val": "Default", "sourcefile": "", "pending_restart": false}, "track_commit_timestamp": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "transaction_deferrable": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "vacuum_cost_page_dirty": {"unit": "", "context": "user", "max_val": "10000", "min_val": "0", "setting": "20", "vartype": "integer", "boot_val": "20", "pretty_val": "20", "sourcefile": "", "pending_restart": false}, "wal_writer_flush_after": {"unit": "8kB", "context": "sighup", "max_val": "2147483647", "min_val": "0", "setting": "128", "vartype": "integer", "boot_val": "128", "pretty_val": "1MB", "sourcefile": "", "val_in_bytes": 1048576, "pending_restart": false}, "allow_system_table_mods": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "archive_cleanup_command": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "bgwriter_lru_multiplier": {"unit": "", "context": "sighup", "max_val": "10", "min_val": "0", "setting": "2", "vartype": "real", "boot_val": "2", "pretty_val": "2", "sourcefile": "", "pending_restart": false}, "ignore_checksum_failure": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "jit_optimize_above_cost": {"unit": "", "context": "user", "max_val": "1.79769e+308", "min_val": "-1", "setting": "500000", "vartype": "real", "boot_val": "500000", "pretty_val": "500000", "sourcefile": "", "pending_restart": false}, "local_preload_libraries": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "log_min_error_statement": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "error", "vartype": "enum", "boot_val": "error", "pretty_val": "error", "sourcefile": "", "pending_restart": false}, "max_pred_locks_per_page": {"unit": "", "context": "sighup", "max_val": "2147483647", "min_val": "0", "setting": "2", "vartype": "integer", "boot_val": "2", "pretty_val": "2", "sourcefile": "", "pending_restart": false}, "syslog_sequence_numbers": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "tcp_keepalives_interval": {"unit": "s", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "trace_recovery_messages": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "log", "vartype": "enum", "boot_val": "log", "pretty_val": "log", "sourcefile": "", "pending_restart": false}, "unix_socket_directories": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "/var/run/postgresql, /tmp", "vartype": "string", "boot_val": "/var/run/postgresql, /tmp", "pretty_val": "/var/run/postgresql, /tmp", "sourcefile": "", "pending_restart": false}, "unix_socket_permissions": {"unit": "", "context": "postmaster", "max_val": "511", "min_val": "0", "setting": "0777", "vartype": "integer", "boot_val": "511", "pretty_val": "0777", "sourcefile": "", "pending_restart": false}, "vacuum_freeze_table_age": {"unit": "", "context": "user", "max_val": "2000000000", "min_val": "0", "setting": "150000000", "vartype": "integer", "boot_val": "150000000", "pretty_val": "150000000", "sourcefile": "", "pending_restart": false}, "effective_io_concurrency": {"unit": "", "context": "user", "max_val": "1000", "min_val": "0", "setting": "1", "vartype": "integer", "boot_val": "1", "pretty_val": "1", "sourcefile": "", "pending_restart": false}, "enable_partition_pruning": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "log_replication_commands": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "log_truncate_on_rotation": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "off", "pretty_val": "on", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "recovery_min_apply_delay": {"unit": "ms", "context": "sighup", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "recovery_target_timeline": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "latest", "vartype": "string", "boot_val": "latest", "pretty_val": "latest", "sourcefile": "", "pending_restart": false}, "session_replication_role": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "origin", "vartype": "enum", "boot_val": "origin", "pretty_val": "origin", "sourcefile": "", "pending_restart": false}, "shared_preload_libraries": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "ssl_max_protocol_version": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "enum", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "ssl_min_protocol_version": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "TLSv1", "vartype": "enum", "boot_val": "TLSv1", "pretty_val": "TLSv1", "sourcefile": "", "pending_restart": false}, "vacuum_defer_cleanup_age": {"unit": "", "context": "sighup", "max_val": "1000000", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "wal_consistency_checking": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "autovacuum_freeze_max_age": {"unit": "", "context": "postmaster", "max_val": "2000000000", "min_val": "100000", "setting": "200000000", "vartype": "integer", "boot_val": "200000000", "pretty_val": "200000000", "sourcefile": "", "pending_restart": false}, "default_statistics_target": {"unit": "", "context": "user", "max_val": "10000", "min_val": "1", "setting": "100", "vartype": "integer", "boot_val": "100", "pretty_val": "100", "sourcefile": "", "pending_restart": false}, "enable_partitionwise_join": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "max_locks_per_transaction": {"unit": "", "context": "postmaster", "max_val": "2147483647", "min_val": "10", "setting": "64", "vartype": "integer", "boot_val": "64", "pretty_val": "64", "sourcefile": "", "pending_restart": false}, "max_prepared_transactions": {"unit": "", "context": "postmaster", "max_val": "262143", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "max_standby_archive_delay": {"unit": "ms", "context": "sighup", "max_val": "2147483647", "min_val": "-1", "setting": "30000", "vartype": "integer", "boot_val": "30000", "pretty_val": "30s", "sourcefile": "", "pending_restart": false}, "recovery_target_inclusive": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "session_preload_libraries": {"unit": "", "context": "superuser", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "ssl_prefer_server_ciphers": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "synchronous_standby_names": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "", "vartype": "string", "boot_val": "", "pretty_val": "", "sourcefile": "", "pending_restart": false}, "track_activity_query_size": {"unit": "B", "context": "postmaster", "max_val": "102400", "min_val": "100", "setting": "1024", "vartype": "integer", "boot_val": "1024", "pretty_val": "1kB", "sourcefile": "", "pending_restart": false}, "default_text_search_config": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "pg_catalog.english", "vartype": "string", "boot_val": "pg_catalog.simple", "pretty_val": "pg_catalog.english", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "dynamic_shared_memory_type": {"unit": "", "context": "postmaster", "max_val": "", "min_val": "", "setting": "posix", "vartype": "enum", "boot_val": "posix", "pretty_val": "posix", "sourcefile": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf", "pending_restart": false}, "log_min_duration_statement": {"unit": "ms", "context": "superuser", "max_val": "2147483647", "min_val": "-1", "setting": "-1", "vartype": "integer", "boot_val": "-1", "pretty_val": "-1", "sourcefile": "", "pending_restart": false}, "autovacuum_vacuum_threshold": {"unit": "", "context": "sighup", "max_val": "2147483647", "min_val": "0", "setting": "50", "vartype": "integer", "boot_val": "50", "pretty_val": "50", "sourcefile": "", "pending_restart": false}, "default_table_access_method": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "heap", "vartype": "string", "boot_val": "heap", "pretty_val": "heap", "sourcefile": "", "pending_restart": false}, "log_autovacuum_min_duration": {"unit": "ms", "context": "sighup", "max_val": "2147483647", "min_val": "-1", "setting": "-1", "vartype": "integer", "boot_val": "-1", "pretty_val": "-1", "sourcefile": "", "pending_restart": false}, "log_transaction_sample_rate": {"unit": "", "context": "superuser", "max_val": "1", "min_val": "0", "setting": "0", "vartype": "real", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "max_pred_locks_per_relation": {"unit": "", "context": "sighup", "max_val": "2147483647", "min_val": "-2147483648", "setting": "-2", "vartype": "integer", "boot_val": "-2", "pretty_val": "-2", "sourcefile": "", "pending_restart": false}, "max_standby_streaming_delay": {"unit": "ms", "context": "sighup", "max_val": "2147483647", "min_val": "-1", "setting": "30000", "vartype": "integer", "boot_val": "30000", "pretty_val": "30s", "sourcefile": "", "pending_restart": false}, "operator_precedence_warning": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "standard_conforming_strings": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "wal_retrieve_retry_interval": {"unit": "ms", "context": "sighup", "max_val": "2147483647", "min_val": "1", "setting": "5000", "vartype": "integer", "boot_val": "5000", "pretty_val": "5s", "sourcefile": "", "pending_restart": false}, "autovacuum_analyze_threshold": {"unit": "", "context": "sighup", "max_val": "2147483647", "min_val": "0", "setting": "50", "vartype": "integer", "boot_val": "50", "pretty_val": "50", "sourcefile": "", "pending_restart": false}, "autovacuum_vacuum_cost_delay": {"unit": "ms", "context": "sighup", "max_val": "100", "min_val": "-1", "setting": "2", "vartype": "real", "boot_val": "2", "pretty_val": "2ms", "sourcefile": "", "pending_restart": false}, "autovacuum_vacuum_cost_limit": {"unit": "", "context": "sighup", "max_val": "10000", "min_val": "-1", "setting": "-1", "vartype": "integer", "boot_val": "-1", "pretty_val": "-1", "sourcefile": "", "pending_restart": false}, "checkpoint_completion_target": {"unit": "", "context": "sighup", "max_val": "1", "min_val": "0", "setting": "0.5", "vartype": "real", "boot_val": "0.5", "pretty_val": "0.5", "sourcefile": "", "pending_restart": false}, "min_parallel_index_scan_size": {"unit": "8kB", "context": "user", "max_val": "715827882", "min_val": "0", "setting": "64", "vartype": "integer", "boot_val": "64", "pretty_val": "512kB", "sourcefile": "", "val_in_bytes": 524288, "pending_restart": false}, "min_parallel_table_scan_size": {"unit": "8kB", "context": "user", "max_val": "715827882", "min_val": "0", "setting": "1024", "vartype": "integer", "boot_val": "1024", "pretty_val": "8MB", "sourcefile": "", "val_in_bytes": 8388608, "pending_restart": false}, "wal_receiver_status_interval": {"unit": "s", "context": "sighup", "max_val": "2147483", "min_val": "0", "setting": "10", "vartype": "integer", "boot_val": "10", "pretty_val": "10s", "sourcefile": "", "pending_restart": false}, "default_transaction_isolation": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "read committed", "vartype": "enum", "boot_val": "read committed", "pretty_val": "read committed", "sourcefile": "", "pending_restart": false}, "default_transaction_read_only": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "parallel_leader_participation": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "on", "vartype": "bool", "boot_val": "on", "pretty_val": "on", "sourcefile": "", "pending_restart": false}, "autovacuum_vacuum_scale_factor": {"unit": "", "context": "sighup", "max_val": "100", "min_val": "0", "setting": "0.2", "vartype": "real", "boot_val": "0.2", "pretty_val": "0.2", "sourcefile": "", "pending_restart": false}, "default_transaction_deferrable": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "enable_partitionwise_aggregate": {"unit": "", "context": "user", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}, "max_pred_locks_per_transaction": {"unit": "", "context": "postmaster", "max_val": "2147483647", "min_val": "10", "setting": "64", "vartype": "integer", "boot_val": "64", "pretty_val": "64", "sourcefile": "", "pending_restart": false}, "superuser_reserved_connections": {"unit": "", "context": "postmaster", "max_val": "262143", "min_val": "0", "setting": "3", "vartype": "integer", "boot_val": "3", "pretty_val": "3", "sourcefile": "", "pending_restart": false}, "autovacuum_analyze_scale_factor": {"unit": "", "context": "sighup", "max_val": "100", "min_val": "0", "setting": "0.1", "vartype": "real", "boot_val": "0.1", "pretty_val": "0.1", "sourcefile": "", "pending_restart": false}, "max_logical_replication_workers": {"unit": "", "context": "postmaster", "max_val": "262143", "min_val": "0", "setting": "4", "vartype": "integer", "boot_val": "4", "pretty_val": "4", "sourcefile": "", "pending_restart": false}, "max_parallel_workers_per_gather": {"unit": "", "context": "user", "max_val": "1024", "min_val": "0", "setting": "2", "vartype": "integer", "boot_val": "2", "pretty_val": "2", "sourcefile": "", "pending_restart": false}, "vacuum_multixact_freeze_min_age": {"unit": "", "context": "user", "max_val": "1000000000", "min_val": "0", "setting": "5000000", "vartype": "integer", "boot_val": "5000000", "pretty_val": "5000000", "sourcefile": "", "pending_restart": false}, "max_parallel_maintenance_workers": {"unit": "", "context": "user", "max_val": "1024", "min_val": "0", "setting": "2", "vartype": "integer", "boot_val": "2", "pretty_val": "2", "sourcefile": "", "pending_restart": false}, "max_sync_workers_per_subscription": {"unit": "", "context": "sighup", "max_val": "262143", "min_val": "0", "setting": "2", "vartype": "integer", "boot_val": "2", "pretty_val": "2", "sourcefile": "", "pending_restart": false}, "vacuum_cleanup_index_scale_factor": {"unit": "", "context": "user", "max_val": "1e+10", "min_val": "0", "setting": "0.1", "vartype": "real", "boot_val": "0.1", "pretty_val": "0.1", "sourcefile": "", "pending_restart": false}, "vacuum_multixact_freeze_table_age": {"unit": "", "context": "user", "max_val": "2000000000", "min_val": "0", "setting": "150000000", "vartype": "integer", "boot_val": "150000000", "pretty_val": "150000000", "sourcefile": "", "pending_restart": false}, "autovacuum_multixact_freeze_max_age": {"unit": "", "context": "postmaster", "max_val": "2000000000", "min_val": "10000", "setting": "400000000", "vartype": "integer", "boot_val": "400000000", "pretty_val": "400000000", "sourcefile": "", "pending_restart": false}, "idle_in_transaction_session_timeout": {"unit": "ms", "context": "user", "max_val": "2147483647", "min_val": "0", "setting": "0", "vartype": "integer", "boot_val": "0", "pretty_val": "0", "sourcefile": "", "pending_restart": false}, "ssl_passphrase_command_supports_reload": {"unit": "", "context": "sighup", "max_val": "", "min_val": "", "setting": "off", "vartype": "bool", "boot_val": "off", "pretty_val": "off", "sourcefile": "", "pending_restart": false}}, "warnings": ["Module did not set no_log for login_password"], "databases": {"ansible": {"size": "9274223", "ctype": "en_US.UTF-8", "owner": "postgres", "collate": "en_US.UTF-8", "encoding": "UTF8", "languages": {"c": {"lanacl": "", "lanowner": "postgres"}, "sql": {"lanacl": "", "lanowner": "postgres"}, "plpgsql": {"lanacl": "", "lanowner": "postgres"}, "internal": {"lanacl": "", "lanowner": "postgres"}}, "extensions": {"plpgsql": {"nspname": "pg_catalog", "extversion": {"major": 1, "minor": 0}, "description": "PL/pgSQL procedural language"}}, "namespaces": {"public": {"nspacl": "{postgres=UC/postgres,=UC/postgres}", "nspowner": "postgres"}, "pg_toast": {"nspacl": "", "nspowner": "postgres"}, "pg_temp_1": {"nspacl": "", "nspowner": "postgres"}, "pg_catalog": {"nspacl": "{postgres=UC/postgres,=U/postgres}", "nspowner": "postgres"}, "pg_toast_temp_1": {"nspacl": "", "nspowner": "postgres"}, "information_schema": {"nspacl": "{postgres=UC/postgres,=U/postgres}", "nspowner": "postgres"}}, "access_priv": "=Tc/postgres\npostgres=CTc/postgres\nansible=CTc/postgres"}, "icinga2": {"size": "8577903", "ctype": "en_US.UTF-8", "owner": "postgres", "collate": "en_US.UTF-8", "encoding": "UTF8", "languages": {"c": {"lanacl": "", "lanowner": "postgres"}, "sql": {"lanacl": "", "lanowner": "postgres"}, "plpgsql": {"lanacl": "", "lanowner": "postgres"}, "internal": {"lanacl": "", "lanowner": "postgres"}, "plpythonu": {"lanacl": "", "lanowner": "postgres"}}, "extensions": {"pg_trgm": {"nspname": "synthezoid", "extversion": {"major": 1, "minor": 4}, "description": "text similarity measurement and index searching based on trigrams"}, "plpgsql": {"nspname": "pg_catalog", "extversion": {"major": 1, "minor": 0}, "description": "PL/pgSQL procedural language"}}, "namespaces": {"public": {"nspacl": "{postgres=UC/postgres,=UC/postgres}", "nspowner": "postgres"}, "pg_toast": {"nspacl": "", "nspowner": "postgres"}, "pg_temp_1": {"nspacl": "", "nspowner": "postgres"}, "pg_catalog": {"nspacl": "{postgres=UC/postgres,=U/postgres}", "nspowner": "postgres"}, "synthezoid": {"nspacl": "", "nspowner": "postgres"}, "pg_toast_temp_1": {"nspacl": "", "nspowner": "postgres"}, "information_schema": {"nspacl": "{postgres=UC/postgres,=U/postgres}", "nspowner": "postgres"}}, "access_priv": "=Tc/postgres\npostgres=CTc/postgres\ntestuser=CTc/postgres\nread_only=CTc/postgres"}, "postgres": {"size": "8520559", "ctype": "en_US.UTF-8", "owner": "postgres", "collate": "en_US.UTF-8", "encoding": "UTF8", "languages": {"c": {"lanacl": "", "lanowner": "postgres"}, "sql": {"lanacl": "", "lanowner": "postgres"}, "plpgsql": {"lanacl": "", "lanowner": "postgres"}, "internal": {"lanacl": "", "lanowner": "postgres"}}, "extensions": {"plpgsql": {"nspname": "pg_catalog", "extversion": {"major": 1, "minor": 0}, "description": "PL/pgSQL procedural language"}}, "namespaces": {"public": {"nspacl": "{postgres=UC/postgres,=UC/postgres}", "nspowner": "postgres"}, "pg_toast": {"nspacl": "", "nspowner": "postgres"}, "pg_temp_1": {"nspacl": "", "nspowner": "postgres"}, "pg_catalog": {"nspacl": "{postgres=UC/postgres,=U/postgres}", "nspowner": "postgres"}, "pg_toast_temp_1": {"nspacl": "", "nspowner": "postgres"}, "information_schema": {"nspacl": "{postgres=UC/postgres,=U/postgres}", "nspowner": "postgres"}}, "access_priv": ""}, "template1": {"size": "8389487", "ctype": "en_US.UTF-8", "owner": "postgres", "collate": "en_US.UTF-8", "encoding": "UTF8", "languages": {"c": {"lanacl": "", "lanowner": "postgres"}, "sql": {"lanacl": "", "lanowner": "postgres"}, "plpgsql": {"lanacl": "", "lanowner": "postgres"}, "internal": {"lanacl": "", "lanowner": "postgres"}}, "extensions": {"plpgsql": {"nspname": "pg_catalog", "extversion": {"major": 1, "minor": 0}, "description": "PL/pgSQL procedural language"}}, "namespaces": {"public": {"nspacl": "{postgres=UC/postgres,=UC/postgres}", "nspowner": "postgres"}, "pg_toast": {"nspacl": "", "nspowner": "postgres"}, "pg_temp_1": {"nspacl": "", "nspowner": "postgres"}, "pg_catalog": {"nspacl": "{postgres=UC/postgres,=U/postgres}", "nspowner": "postgres"}, "pg_toast_temp_1": {"nspacl": "", "nspowner": "postgres"}, "information_schema": {"nspacl": "{postgres=UC/postgres,=U/postgres}", "nspowner": "postgres"}}, "access_priv": "=c/postgres\npostgres=CTc/postgres"}}, "invocation": {"module_args": {"db": null, "port": 5432, "filter": null, "ca_cert": null, "database": "ansible", "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "session_role": null, "login_password": "", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "repl_slots": {"physical_gg": {"active": false, "plugin": null, "database": null, "slot_type": "physical"}}, "tablespaces": {"pg_global": {"spcacl": "", "spcowner": "postgres", "spcoptions": []}, "pg_default": {"spcacl": "", "spcowner": "postgres", "spcoptions": []}}, "replications": {}, "_ansible_no_log": false, "pending_restart_settings": []}', '2021-10-09 18:41:26.000000 +00:00', 1464, 'v2_runner_on_ok');
  63. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "name": "pg_trgm", "schema": "synthezoid", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Adds pg_trgm extension", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000015", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_ext", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:26.000000 +00:00', 1465, 'v2_playbook_on_task_start');
  64. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "name": "pg_trgm", "schema": "synthezoid", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Adds pg_trgm extension", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000015", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_ext", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:26.000000 +00:00', 1466, 'v2_runner_on_start');
  65. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"db": "icinga2", "ext": "pg_trgm", "changed": false, "queries": [], "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "ext": "pg_trgm", "name": "pg_trgm", "port": 5432, "state": "present", "schema": "synthezoid", "ca_cert": null, "cascade": false, "version": null, "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "session_role": null, "login_password": "", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "_ansible_no_log": false}', '2021-10-09 18:41:27.000000 +00:00', 1467, 'v2_runner_on_ok');
  66. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "state": "present", "table": "icinga_commands", "columns": ["command_id"], "idxname": "test", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Add index", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000016", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_idx", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:27.000000 +00:00', 1468, 'v2_playbook_on_task_start');
  67. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "state": "present", "table": "icinga_commands", "columns": ["command_id"], "idxname": "test", "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}, "diff": false, "loop": null, "name": "Add index", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000016", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_idx", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:27.000000 +00:00', 1469, 'v2_runner_on_start');
  68. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"name": "test", "query": "", "state": "present", "valid": true, "schema": "public", "changed": false, "tblname": "icinga_commands", "tblspace": "", "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "cond": null, "port": 5432, "state": "present", "table": "icinga_commands", "schema": null, "ca_cert": null, "cascade": false, "columns": ["command_id"], "idxname": "test", "idxtype": null, "ssl_mode": "prefer", "concurrent": true, "login_host": "", "login_user": "postgres", "tablespace": null, "session_role": null, "login_password": "", "storage_params": null, "login_unix_socket": "/var/run/postgresql/.s.PGSQL.5432"}}, "storage_params": [], "_ansible_no_log": false}', '2021-10-09 18:41:29.000000 +00:00', 1470, 'v2_runner_on_ok');
  69. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"dest": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_hba.conf"}, "diff": false, "loop": null, "name": "pg_hda.conf content", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000017", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_pg_hba", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:29.000000 +00:00', 1471, 'v2_playbook_on_task_start');
  70. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"dest": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_hba.conf"}, "diff": false, "loop": null, "name": "pg_hda.conf content", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000017", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_pg_hba", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:29.000000 +00:00', 1472, 'v2_runner_on_start');
  71. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"msgs": [], "pg_hba": [{"db": "replication", "usr": "all", "type": "local", "method": "trust"}, {"db": "all", "usr": "all", "type": "local", "method": "trust"}, {"db": "replication", "src": "127.0.0.1/32", "usr": "all", "type": "host", "method": "trust"}, {"db": "replication", "src": "::1/128", "usr": "all", "type": "host", "method": "trust"}, {"db": "all", "src": "127.0.0.1/32", "usr": "all", "type": "host", "method": "trust"}, {"db": "all", "src": "::1/128", "usr": "all", "type": "host", "method": "trust"}], "changed": false, "invocation": {"module_args": {"src": null, "dest": "/var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_hba.conf", "mode": null, "force": null, "group": null, "order": "sdu", "owner": null, "state": "present", "users": "all", "backup": null, "create": false, "follow": false, "method": "md5", "regexp": null, "serole": null, "setype": null, "seuser": null, "address": "samehost", "content": null, "contype": null, "netmask": null, "options": null, "selevel": null, "databases": "all", "delimiter": null, "attributes": null, "remote_src": null, "backup_file": null, "unsafe_writes": null, "directory_mode": null}}, "_ansible_no_log": false}', '2021-10-09 18:41:30.000000 +00:00', 1473, 'v2_runner_on_ok');
  72. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "lang": "plpythonu", "state": "present", "trust": true, "force_trust": true}, "diff": false, "loop": null, "name": "Add language plpython", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000018", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_lang", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:30.000000 +00:00', 1474, 'v2_playbook_on_task_start');
  73. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "lang": "plpythonu", "state": "present", "trust": true, "force_trust": true}, "diff": false, "loop": null, "name": "Add language plpython", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000018", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_lang", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:30.000000 +00:00', 1475, 'v2_runner_on_start');
  74. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"db": "icinga2", "lang": "plpythonu", "trust": true, "changed": false, "queries": [], "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "lang": "plpythonu", "port": 5432, "state": "present", "trust": true, "ca_cert": null, "cascade": false, "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "force_trust": true, "fail_on_drop": true, "session_role": null, "login_password": "", "login_unix_socket": ""}}, "_ansible_no_log": false}', '2021-10-09 18:41:31.000000 +00:00', 1476, 'v2_runner_on_ok');
  75. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "state": "present", "slot_name": "physical_gg"}, "diff": false, "loop": null, "name": "Add slot", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000019", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_slot", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:31.000000 +00:00', 1477, 'v2_playbook_on_task_start');
  76. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "state": "present", "slot_name": "physical_gg"}, "diff": false, "loop": null, "name": "Add slot", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-000000000019", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_slot", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:31.000000 +00:00', 1478, 'v2_runner_on_start');
  77. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"name": "physical_gg", "changed": false, "queries": [], "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "name": "physical_gg", "port": 5432, "state": "present", "ca_cert": null, "ssl_mode": "prefer", "slot_name": "physical_gg", "slot_type": "physical", "login_host": "", "login_user": "postgres", "session_role": null, "output_plugin": "test_decoding", "login_password": "", "login_unix_socket": "", "immediately_reserve": false}}, "_ansible_no_log": false}', '2021-10-09 18:41:32.000000 +00:00', 1479, 'v2_runner_on_ok');
  78. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"name": "wal_log_hints", "value": "default"}, "diff": false, "loop": null, "name": "Set wal_log_hints parameter to default value (remove parameter from postgresql.auto.conf)", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001a", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_set", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:32.000000 +00:00', 1480, 'v2_playbook_on_task_start');
  79. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"name": "wal_log_hints", "value": "default"}, "diff": false, "loop": null, "name": "Set wal_log_hints parameter to default value (remove parameter from postgresql.auto.conf)", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001a", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_set", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:32.000000 +00:00', 1481, 'v2_runner_on_start');
  80. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"name": "wal_log_hints", "changed": true, "context": "postmaster", "warnings": ["Module did not set no_log for login_password", "Restart of PostgreSQL is required for setting wal_log_hints"], "invocation": {"module_args": {"db": null, "name": "wal_log_hints", "port": 5432, "reset": null, "value": "default", "ca_cert": null, "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "session_role": null, "login_password": "", "login_unix_socket": ""}}, "value_pretty": "default", "_ansible_no_log": false, "prev_val_pretty": "off", "restart_required": true}', '2021-10-09 18:41:34.000000 +00:00', 1482, 'v2_runner_on_ok');
  81. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "obj_name": "icinga_commands", "obj_type": "table", "new_owner": "testuser"}, "diff": false, "loop": null, "name": "Give ownership", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001b", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_owner", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:34.000000 +00:00', 1483, 'v2_playbook_on_task_start');
  82. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "obj_name": "icinga_commands", "obj_type": "table", "new_owner": "testuser"}, "diff": false, "loop": null, "name": "Give ownership", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001b", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_owner", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:34.000000 +00:00', 1484, 'v2_runner_on_start');
  83. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"changed": false, "queries": [], "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": "icinga2", "port": 5432, "ca_cert": null, "obj_name": "icinga_commands", "obj_type": "table", "ssl_mode": "prefer", "new_owner": "testuser", "login_host": "", "login_user": "postgres", "fail_on_role": true, "session_role": null, "login_password": "", "login_unix_socket": "", "reassign_owned_by": null}}, "_ansible_no_log": false}', '2021-10-09 18:41:35.000000 +00:00', 1485, 'v2_runner_on_ok');
  84. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"db": "icinga2", "name": "test_pub", "state": "present", "tables": ["icinga_commands"]}, "diff": false, "loop": null, "name": "Tets publication", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001c", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_publication", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:35.000000 +00:00', 1486, 'v2_playbook_on_task_start');
  85. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"db": "icinga2", "name": "test_pub", "state": "present", "tables": ["icinga_commands"]}, "diff": false, "loop": null, "name": "Tets publication", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001c", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_publication", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:35.000000 +00:00', 1487, 'v2_runner_on_start');
  86. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"owner": "postgres", "exists": true, "tables": ["\"public\".\"icinga_commands\""], "changed": false, "queries": [], "warnings": ["Module did not set no_log for login_password"], "alltables": false, "invocation": {"module_args": {"db": "icinga2", "name": "test_pub", "port": 5432, "owner": null, "state": "present", "tables": ["\"public\".\"icinga_commands\""], "ca_cert": null, "cascade": false, "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "parameters": null, "login_password": "", "login_unix_socket": ""}}, "parameters": {"publish": {"delete": true, "insert": true, "update": true, "truncate": true}}, "_ansible_no_log": false}', '2021-10-09 18:41:36.000000 +00:00', 1488, 'v2_runner_on_ok');
  87. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"src": "icinga_commands", "copy_to": "/tmp/data.txt"}, "diff": false, "loop": null, "name": "Copy data from acme table to file /tmp/data.txt in text format, TAB-separated", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001d", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_copy", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:36.000000 +00:00', 1489, 'v2_playbook_on_task_start');
  88. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"src": "icinga_commands", "copy_to": "/tmp/data.txt"}, "diff": false, "loop": null, "name": "Copy data from acme table to file /tmp/data.txt in text format, TAB-separated", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001d", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_copy", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:36.000000 +00:00', 1490, 'v2_runner_on_start');
  89. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"dst": "/tmp/data.txt", "src": "icinga_commands", "changed": true, "queries": ["COPY \"icinga_commands\" TO ''/tmp/data.txt''"], "warnings": ["Module did not set no_log for login_password", "Database name has not been passed, used default database to connect to."], "invocation": {"module_args": {"db": null, "dst": null, "src": "icinga_commands", "port": 5432, "ca_cert": null, "columns": null, "copy_to": "/tmp/data.txt", "options": null, "program": false, "ssl_mode": "prefer", "copy_from": null, "login_host": "", "login_user": "postgres", "session_role": null, "login_password": "", "login_unix_socket": ""}}, "_ansible_no_log": false}', '2021-10-09 18:41:38.000000 +00:00', 1491, 'v2_runner_on_ok');
  90. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"args": {"group": "read_only", "state": "present", "target_roles": ["testuser"]}, "diff": false, "loop": null, "name": "Grant role read_only to test user", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001e", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_membership", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "is_conditional": false, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}', '2021-10-09 18:41:38.000000 +00:00', 1492, 'v2_playbook_on_task_start');
  91. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"host": {"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": [{"name": "localhost", "uuid": "080027ab-7d7e-549d-c79d-000000000005", "vars": {"inventory_dir": "/opt/logging", "inventory_file": "/opt/logging/inventory.yml", "ansible_connection": "local", "ansible_python_interpreter": "/usr/bin/python3"}, "groups": [{"name": "databases", "vars": {"telegram_chat": "@pro_ansible"}, "depth": 1, "hosts": ["080027ab-7d7e-549d-c79d-000000000005"], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}], "parent_groups": [{"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}]}, {"name": "all", "vars": {}, "depth": 0, "hosts": [], "parent_groups": []}], "address": "localhost", "implicit": false}, "task": {"args": {"group": "read_only", "state": "present", "target_roles": ["testuser"]}, "diff": false, "loop": null, "name": "Grant role read_only to test user", "poll": 15, "port": null, "tags": [], "uuid": "080027ab-7d7e-549d-c79d-00000000001e", "vars": {}, "when": [], "async": 0, "delay": 5, "until": [], "action": "postgresql_membership", "become": true, "no_log": null, "notify": null, "parent": {"eor": false, "diff": false, "name": "", "port": null, "tags": [], "vars": {}, "when": [], "become": true, "no_log": null, "debugger": null, "run_once": null, "throttle": 0, "dep_chain": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": null, "remote_user": null, "become_flags": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": null, "any_errors_fatal": false, "ignore_unreachable": null}, "retries": 3, "debugger": null, "register": null, "run_once": null, "squashed": false, "throttle": 0, "async_val": 0, "finalized": false, "loop_with": null, "become_exe": null, "check_mode": false, "connection": "smart", "become_user": "postgres", "collections": [], "delegate_to": null, "environment": [], "failed_when": [], "parent_type": "Block", "remote_user": null, "become_flags": null, "changed_when": [], "loop_control": null, "become_method": "sudo", "ignore_errors": null, "delegate_facts": null, "module_defaults": [], "any_errors_fatal": false, "ignore_unreachable": null}}', '2021-10-09 18:41:38.000000 +00:00', 1493, 'v2_runner_on_start');
  92. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"state": "present", "groups": ["read_only"], "changed": false, "granted": {"read_only": []}, "queries": [], "warnings": ["Module did not set no_log for login_password"], "invocation": {"module_args": {"db": null, "port": 5432, "group": "read_only", "state": "present", "groups": ["read_only"], "ca_cert": null, "ssl_mode": "prefer", "login_host": "", "login_user": "postgres", "fail_on_role": true, "session_role": null, "target_roles": ["testuser"], "login_password": "", "login_unix_socket": ""}}, "target_roles": ["testuser"], "_ansible_no_log": false}', '2021-10-09 18:41:39.000000 +00:00', 1494, 'v2_runner_on_ok');
  93. INSERT INTO public.logs (uuid, DATA, TIMESTAMP, id, origin) VALUES ('080027ab-7d7e-549d-c79d-00000000001f', '{"localhost": {"ok": 23, "failed": 0, "changed": 4, "ignored": 0, "rescued": 0, "skipped": 0, "unreachable": 0}}', '2021-10-09 18:41:39.000000 +00:00', 1495, 'v2_playbook_on_stats');
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!