ó
ÑKjc @ s d d l Z d d l m Z m Z m Z m Z d d l m Z d e f d „ ƒ YZ d e e f d „ ƒ YZ d e e e f d „ ƒ YZ
d S(
iÿÿÿÿN( t Plugint UbuntuPlugint DebianPlugint SCLPlugin( t findt
PostgreSQLc B sf e Z d Z d Z d Z d Z d Z d d d d
e d d f d d d g Z d d d „ Z d „ Z
RS( s PostgreSQL RDBMSt
postgresqlt servicess postgresql-commons' (password visible in process listings)t pghomes! PostgreSQL server home directory.t s /var/lib/pgsqlt usernames username for pg_dumpt postgrest passwords password for pg_dumpt dbnames! database name to dump for pg_dumpt dbhosts- database hostname/IP (do not use unix socket)t dbports database server port numbert 5432s
pgdump.tarc C s* | j d ƒ r&| j d ƒ s- d t j k r| j d ƒ rU | j d ƒ t j d <n | j d ƒ r¡ d | j d ƒ | j d ƒ | j d ƒ | j d ƒ f } n" d | j d ƒ | j d ƒ f } | d k rä | j | | ƒ } n | j | d | d
t d d ƒq&| j j d
ƒ | j d ƒ n d S( NR
R t
PGPASSWORDR s$ pg_dump -U %s -h %s -p %s -w -F t %sR
R s pg_dump -C -U %s -w -F t %s t suggest_filenamet binaryt sizelimiti s- password must be supplied to dump a database.s3 WARN: password must be supplied to dump a database.(
t
get_optiont ost environt Nonet convert_cmd_sclt add_cmd_outputt Truet soslogt warningt add_alert( t selft sclt filenamet cmd( ( s: /usr/lib/python2.7/site-packages/sos/plugins/postgresql.pyt
do_pg_dump( s* c C s( | j ƒ | j d | j d ƒ ƒ d S( Ns du -sh %sR ( R# R R ( R ( ( s: /usr/lib/python2.7/site-packages/sos/plugins/postgresql.pyt setupK s
( R ( R s postgresql-common( s pghomes! PostgreSQL server home directory.R s /var/lib/pgsql( s usernames username for pg_dumpR R ( s dbnames! database name to dump for pg_dumpR R ( s dbhosts- database hostname/IP (do not use unix socket)R R ( s dbports database server port numberR R N( t __name__t
__module__t __doc__t plugin_namet profilest packagest password_warn_textt option_listR R# R$ ( ( ( s: /usr/lib/python2.7/site-packages/sos/plugins/postgresql.pyR s #t RedHatPostgreSQLc B s e Z d Z d „ Z RS( R s! rh-postgresql95-postgresql-servers! rh-postgresql10-postgresql-servers! rh-postgresql12-postgresql-serverc C s{ t t | ƒ j ƒ | j d ƒ } | g } x´ | j d D]¥ } | j d ƒ d } | j | | ƒ } | j | ƒ t j j
| ƒ r— | j d | ƒ n | j | j
d d ƒ ƒ r9 | | j k r9 | j d | d d
| ƒ q9 q9 Wx’ | D]Š } x$ t d | ƒ D] } | j | ƒ qÿ Wx$ t d | ƒ D] } | j | ƒ q&Wx3 d
d g D]% } | j t j j | d | ƒ ƒ qJWqé Wd S( NR i s -postgresql-i s du -sh %ss -serverR R R! s pgdump-scl-%s.tars *.logs *.conft
PG_VERSIONs postmaster.optst data( t superR- R$ R R* t splitt convert_copyspec_sclt appendR t patht isdirR t is_service_runningt replacet scls_matchedR# R t
add_copy_spect join( R R t dirst pkgR t _dirR! t f( ( s: /usr/lib/python2.7/site-packages/sos/plugins/postgresql.pyR$ Y s&
!
( s
postgresqls! rh-postgresql95-postgresql-servers! rh-postgresql10-postgresql-servers! rh-postgresql12-postgresql-server( R% R& R* R$ ( ( ( s: /usr/lib/python2.7/site-packages/sos/plugins/postgresql.pyR- P s
t DebianPostgreSQLc B s e Z d „ Z RS( c C s0 t t | ƒ j ƒ | j d d d d g ƒ d S( Ns /var/log/postgresql/*.logs /etc/postgresql/*/main/*.confs% /var/lib/postgresql/*/main/PG_VERSIONs* /var/lib/postgresql/*/main/postmaster.opts( R0 R? R$ R9 ( R ( ( s: /usr/lib/python2.7/site-packages/sos/plugins/postgresql.pyR$ | s ( R% R& R$ ( ( ( s: /usr/lib/python2.7/site-packages/sos/plugins/postgresql.pyR? z s ( R t sos.pluginsR R R R t
sos.utilitiesR R R- R? ( ( ( s: /usr/lib/python2.7/site-packages/sos/plugins/postgresql.pyt <module> s
";*