VhPddlmZmZmZeZdZdZdZddl m Z ddl m Z ddl mZddlmZdd lmZmZmZmZmZmZgZd Zd Zd Zd ZdZdZdZdZ dZ!dZ"dZ#dZ$e%dk(re$yy))absolute_importdivisionprint_functiona --- module: postgresql_set short_description: Change a PostgreSQL server configuration parameter description: - "IMPORTANT: If your PostgreSQL server version is 14 or later, use the M(community.postgresql.postgresql_alter_system) module instead as it will replace this module in future." - Allows to change a PostgreSQL server configuration parameter. - The module uses ALTER SYSTEM command and applies changes by reload server configuration. - ALTER SYSTEM is used for changing server configuration parameters across the entire database cluster. - It can be more convenient and safe than the traditional method of manually editing the postgresql.conf file. - ALTER SYSTEM writes the given parameter setting to the $PGDATA/postgresql.auto.conf file, which is read in addition to postgresql.conf. - The module allows to reset parameter to boot_val (cluster initial value) by I(reset=true) or remove parameter string from postgresql.auto.conf and reload I(value=default) (for settings with postmaster context restart is required). - After change you can see in the ansible output the previous and the new parameter value and other information using returned values and M(ansible.builtin.debug) module. options: name: description: - Name of PostgreSQL server parameter. Pay attention that parameters are case sensitive (see examples below). type: str required: true value: description: - Parameter value to set. - To remove parameter string from postgresql.auto.conf and reload the server configuration you must pass I(value=default). With I(value=default) the playbook always returns changed is true. type: str reset: description: - Restore parameter to initial state (boot_val). Mutually exclusive with I(value). type: bool default: false session_role: description: - Switch to session_role after connecting. The specified session_role must be a role that the current login_user is a member of. - Permissions checking for SQL commands is carried out as though the session_role were the one that had logged in originally. type: str login_db: description: - Name of database to connect. - The V(db) alias is deprecated and will be removed in version 5.0.0. type: str aliases: - db trust_input: description: - If C(false), check whether values of parameters are potentially dangerous. - It makes sense to use C(false) only when SQL injections are possible. type: bool default: true version_added: '0.2.0' notes: - Supported version of PostgreSQL is 9.4 and later. For PostgreSQL version 14 or later, the M(community.postgresql.postgresql_alter_system) module is recommended. - Pay attention, change setting with 'postmaster' context can return changed is true when actually nothing changes because the same value may be presented in several different form, for example, 1024MB, 1GB, etc. However in pg_settings system view it can be defined like 131072 number of 8kB pages. The final check of the parameter value cannot compare it because the server was not restarted and the value in pg_settings is not updated yet. - For some parameters restart of PostgreSQL server is required. See official documentation U(https://www.postgresql.org/docs/current/view-pg-settings.html). attributes: check_mode: support: full seealso: - module: community.postgresql.postgresql_alter_system - module: community.postgresql.postgresql_info - name: PostgreSQL server configuration description: General information about PostgreSQL server configuration. link: https://www.postgresql.org/docs/current/runtime-config.html - name: PostgreSQL view pg_settings reference description: Complete reference of the pg_settings view documentation. link: https://www.postgresql.org/docs/current/view-pg-settings.html - name: PostgreSQL ALTER SYSTEM command reference description: Complete reference of the ALTER SYSTEM command documentation. link: https://www.postgresql.org/docs/current/sql-altersystem.html author: - Andrew Klychkov (@Andersson007) - Daniele Giudice (@RealGreenDragon) extends_documentation_fragment: - community.postgresql.postgres ah - name: Restore wal_keep_segments parameter to initial state community.postgresql.postgresql_set: name: wal_keep_segments reset: true # Set work_mem parameter to 32MB and show what's been changed and restart is required or not # (output example: "msg": "work_mem 4MB >> 64MB restart_req: False") - name: Set work mem parameter community.postgresql.postgresql_set: name: work_mem value: 32mb register: set - name: Print the result if the setting changed ansible.builtin.debug: msg: "{{ set.name }} {{ set.prev_val_pretty }} >> {{ set.value_pretty }} restart_req: {{ set.restart_required }}" when: set.changed # Ensure that the restart of PostgreSQL server must be required for some parameters. # In this situation you see the same parameter in prev_val_pretty and value_pretty, but 'changed=True' # (If you passed the value that was different from the current server setting). - name: Set log_min_duration_statement parameter to 1 second community.postgresql.postgresql_set: name: log_min_duration_statement value: 1s - name: Set wal_log_hints parameter to default value (remove parameter from postgresql.auto.conf) community.postgresql.postgresql_set: name: wal_log_hints value: default - name: Set TimeZone parameter (careful, case sensitive) community.postgresql.postgresql_set: name: TimeZone value: 'Europe/Paris' an name: description: Name of PostgreSQL server parameter. returned: success type: str sample: 'shared_buffers' restart_required: description: Information about parameter current state. returned: success type: bool sample: true prev_val_pretty: description: Information about previous state of the parameter. returned: success type: str sample: '4MB' value_pretty: description: Information about current state of the parameter. returned: success type: str sample: '64MB' value: description: - Dictionary that contains the current parameter value (at the time of playbook finish). - Pay attention that for real change some parameters restart of PostgreSQL server is required. - Returns the current value in the check mode. returned: success type: dict sample: { "value": 67108864, "unit": "b" } context: description: - PostgreSQL setting context. returned: success type: str sample: user queries: description: - List of executed DML queries. returned: success type: list elements: str sample: ["ALTER SYSTEM SET shared_preload_libraries = ''"] version_added: '3.7.0' )deepcopy) to_native) AnsibleModule) check_input) connect_to_dbensure_required_libsget_conn_paramsget_server_versionpg_cursor_argspostgres_common_argument_spec a)mbgbtb))")local_preload_libraries search_pathsession_preload_librariesshared_preload_librariestemp_tablespacesunix_socket_directories)r)rrrrrc6tD]\}}||k\s ||vcSy)NF)PARAMETERS_GUC_LIST_QUOTE)server_versionnameguc_list_quote_verguc_list_quote_paramss w/home/dcms/DCMS/lib/python3.12/site-packages/ansible_collections/community/postgresql/plugins/modules/postgresql_set.pyparam_is_guc_list_quoter"s25N111 / /00 01 cdj|jdDcgc]}|jdc}Scc}w)Nz, ,z" )joinsplitstrip)valuevs r!param_guc_list_unquoter+s2 99U[[-=>aggdm> ??>s>c d} |j|d|i|j}|jd|z|j}s|jd|z|}|d} |d } |d } |d } |d k(rd }n|dk(rd}| dk(r;t | dkDrt | dz} t | dkDrt | dz} d} nE| dk(r@t | dkDrt | dzdz} t | dkDrt | dzdz} d} |rt |}t | } || | | | dS#t$r,}|jd|dt |Yd}~d}~wwxYw)NzTSELECT name, setting, unit, context, boot_val FROM pg_settings WHERE name = %(name)srzSHOW %szUnable to get z value due to : msgzNo such parameter: %s. Please check its spelling or presence in your PostgreSQL version (https://www.postgresql.org/docs/current/runtime-config.html)settingunitcontextboot_valTrueonFalseoffkBrbMB) current_valraw_valr0r2r1)executefetchone Exception fail_jsonrintr+) cursormoduleris_guc_list_quotequeryinfovaler;r<r0r1r2s r! param_getrIs6EZuvtn- y4'(oo ]_cd ed)K9oG  ! ! # "ZJH yy{  OOA  2778$%HL :! :bc? "#d?L Z_ $#d?T1L Z_ $#d?T1D8L Z_ $#d?T1D84?L C:b>1 W " "":.  "!! "  "s) C'' D1 C?? D DDDc4t|trjd|vrf|jdsU|dkr|dk(sKdj|j dDcgc]}d|j zdzc}}d|d|}n d|d|d}d }t |||||Scc}w) Nr%)_command_prefixrr'zALTER SYSTEM SET z = z = 'z"Unable to set %s value due to : %s) isinstancestrendswithr&r'r( exec_set_sql)rBrCrr)relemrEfail_msgs r! param_setrgus%#, 56&(T5N-Nu{{3?OPt# ,s2PQ.2E:04e<3H tX >> QsBc.d|z}d}t|||||S)NzALTER SYSTEM SET %s = DEFAULTz.Unable to set default value for %s due to : %srdrBrCrrErfs r!param_set_defaultrks$ +d 2E?H tX >>r#c.d|z}d}t|||||S)NzALTER SYSTEM RESET %szUnable to reset %s due to : %srirjs r! param_resetrms$ #d *E/H tX >>r#c tj||j|y#t$r*}|j ||t |fzYd}~yd}~wwxYw)Nr-T)executed_queriesrVr=r?r@r)rBrCrE setting_namerfrHs r!rdrds`F&u  FXy|(DDEE Fs&) A AAc ^ t}|jtddtddgddddgtd td d td td d  t|d}|jd}|jd}|jd}|jd}|jd}|st |||||rut |dkDr/|ddjr|ddtvr|j}n8t |dkDr*d|dvr#|ddjr|j}|dk(r|dk(rd}|j|||r|jd|z||s|jd|zt|t||jd }t||d \} } | jd;it} i} t!| } | t"krV|j%d!| d"t"d#td d ddddd$%} || d<| j'|j(d;i| t+| |}d }d }|| d<d | d&<t-| |||}|d'}|d(}|d)}|d*}|d+}|d,k(rd-}n|d.k(rd/}|| d0<t/| d0| d1<|| d+<|d2k(r|jd3|z|d4k(rd}|j0rWt3|t3|k(rd | d5<n || d1<d| d5<t||$| d<|| d&<t4| d6<|j(d;i| |-||k7r(|d7k(rt7| ||}nt9| |||| }|| d1<n?|r=||k(r+t||$| d<t4| d6<|j(d;i| t;| ||}|j0s|r|d4k7r| j=d8| j'| j'|d9vr~t||d \} } | jd;it} t-| |||}|d'}|d(}||k(rd }nd}|| d1<t||$| d<| j'| j'|| d5<|| d&<t4| d6<|r|r|j%d:|z|j(d;i| y)eCRj002uRSzEY7YKKMEZ!^b !1eCRj6H6H6JKKME ))erkJ S! UPSWWX }UY\``a !&&--OK(NM5 !] ! ! 3N 3F B ] +C Z cS]^_ "+  6 20T:GBvJ"B FFD*;   h BwK-ByM F   "r "ffd3   W -D01 LLNQQ,V[TR u%%%77.?@m$ N i GG$> 7  ByM-B$ByMG FMNFrr#__main__N)& __future__rrrrr __metaclass__ DOCUMENTATIONEXAMPLESRETURNcopyransible.module_utils._textransible.module_utils.basicrFansible_collections.community.postgresql.plugins.module_utils.databaser Fansible_collections.community.postgresql.plugins.module_utils.postgresr r r r rrrorrrr"r+rIr\rgrkrmrdr__name__rr#r!rsA@ ] ~$ L+ Z04  *0@ 6r?D?(? ? }@ zFr#