|
Server IP : 184.107.3.203 / Your IP : 216.73.216.51 Web Server : Apache System : Linux dedicated2.avenfashion.com.ph 4.18.0-553.40.1.el8_10.x86_64 #1 SMP Mon Feb 10 12:11:18 EST 2025 x86_64 User : adminteladeoro ( 1015) PHP Version : 8.2.28 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /usr/lib/python3.6/site-packages/sos/report/plugins/__pycache__/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
3
~ �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�charmed-postgresql)�returnc C s
dt � �S )Nz--config-file )�PATRONI_CONFIG_FILE)�self� r �(/usr/lib/python3.6/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_port)r r r r � psql_args- s zCharmedPostgreSQL.psql_argsc C s | j td � d�td � d�g� | jtd � d�td � td � d�td � td � td
� td � td � g� | jd � | jd
dd� yvttdd��}tj|�}W d Q R X |d | _ |d }|d j
d�}|\| _ | _ |d }|d }|d | _
|d | _W nF ttjttttfk
�rH } z| jdt� d|� �� d S d }~X nX | 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� superuserZusernameZpasswordzVCan 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 Z host_portr r �errorr r r �setup4 sp
zCharmedPostgreSQL.setupc C s^ dt jkrt jd= | jtd � d�dd� | jtd � d�dd � | jtd
� 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)r
) �__name__�
__module__� __qualname__Z
short_descZ plugin_nameZpackages�property�strr r r0 r1 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"