관리-도구
편집 파일: charmed_postgresql.cpython-39.pyc
a -�_g7 � @ s� d dl Z d dlZd dlmZmZ dZdZed ed ed ed ed ed ed ed d �Zed � d�ZdZ dZ dZ G dd� dee�Z dS )� N)�Plugin� UbuntuPluginz#/var/snap/charmed-postgresql/commonz$/var/snap/charmed-postgresql/currentz/var/lib/postgresqlz/var/log/postgresqlz /etc/patroniz/var/log/patroniz/etc/pgbackrestz/var/log/pgbackrestz/etc/pgbouncerz/var/log/pgbouncer)�POSTGRESQL_CONF�POSTGRESQL_LOGS� PATRONI_CONF� PATRONI_LOGS�PGBACKREST_CONF�PGBACKREST_LOGS�PGBOUNCER_CONF�PGBOUNCER_LOGSr z /patroni.yamlZ snap_daemonzcharmed-postgresql.psqlz charmed-postgresql.patronictlc @ sL e Zd ZdZdZdZeed�dd��Zeed�dd��Z d d � Z d d � Z d S )�CharmedPostgreSQLzCharmed PostgreSQLZcharmed_postgresql)zcharmed-postgresql)�returnc C s dt � �S )Nz--config-file )�PATRONI_CONFIG_FILE��self� r �I/usr/lib/python3.9/site-packages/sos/report/plugins/charmed_postgresql.py�patronictl_args) s z!CharmedPostgreSQL.patronictl_argsc C s d| j � d| j� d| j� d�S )Nz-U z -h z -p z -d postgres -P pager=off)�postgresql_username�postgresql_host�postgresql_portr r r r � psql_args- s ��zCharmedPostgreSQL.psql_argsc C s: | � td � d�td � d�g� | �td � d�td � td � d�td � td � td � td � td � g� | �d � | jd dd� z�ttdd��}t�|�}W d � n1 s�0 Y |d | _ |d }|d � d�}|\| _ | _ |d }|d }|d | _ |d | _W nL ttjttttf�yb } z$| �dt� d|� �� W Y d }~d S d }~0 0 | jt� d | j� d | j � �d td � | jt� d | j� d | j � �d!td � | jt� d | j� d"| j � �d#td � | jtjd$< | jt� d | j � d%�d&td � | jt� d | j � d'�d(td � | jt� d | j � d)�d*td � d S )+Nr z/*.pemr r z/*.conf*r z/*.y*mlr r r r zsnap.charmed-postgresql.*z snap info charmed-postgresqlz snap-info)�suggest_filenamezutf-8)�encodingZscope� postgresqlZconnect_address�:�authentication� superuser�username�passwordzVCan not run additional commands due to an error on opening or parsing the config file z: � z topology zpatroni-topology)r Zrunasz history zpatroni-historyz show-config zpatroni-dcs-config� PGPASSWORDz -c '\l+'zpostgresql-databasesz -c '\duS+'zpostgresql-usersz -c '\dtS+'zpostgresql-tables) Zadd_forbidden_path�PATHSZ add_copy_specZ add_journalZadd_cmd_output�openr �yamlZ safe_loadZpatroni_cluster_name�splitr r r Zpostgresql_password�OSErrorZ YAMLError� TypeError� ValueError�KeyError�AttributeErrorZ _log_warn� PATRONICTLr �RUNAS�os�environ�PSQLr )r �fZpatroni_configr � host_portr r �errorr r r �setup4 s� � � �( ����� �� �� � � �zCharmedPostgreSQL.setupc C s^ dt jv rt jd= | �td � d�dd� | �td � d�dd � | �td � d �d d� d S ) Nr! r z/*z(password: )"?.*"?z \1"*********"r z/pgbackrest.confz(.*s3-key.*=).*z \1*********r z/pgbouncer/userlist.txtz (".*" )".*")r- r. Zdo_path_regex_subr" r r r r �postproc� s" � � �zCharmedPostgreSQL.postprocN) �__name__� __module__� __qualname__Z short_descZ plugin_nameZpackages�property�strr r r3 r4 r r r r r # s nr ) r- r$ Zsos.report.pluginsr r ZSNAP_COMMON_PATHZSNAP_CURRENT_PATHr" r r, r/ r+ r r r r r �<module> s$ �