pgcenter 工具

╰+攻爆jí腚メ 2022-12-08 05:16 132阅读 0赞

os: centos 7.4  
db: postgresql 11.9

# 版本 #

# cat /etc/centos-release
    CentOS Linux release 7.4.1708 (Core) 
    #
    # su - postgres
    Last login: Tue Oct 22 13:56:27 CST 2019 on pts/0
    $
    $ psql -c "select version();"
                                                     version                                                 
    ---------------------------------------------------------------------------------------------------------
     PostgreSQL 11.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
    (1 row)

# 下载安装 #

# yum install perl perl-CPAN 
    # perl -MCPAN -e shell
    cpan[1]> install Linux::Ethtool::Settings
    cpan[1]> q

# su - postgres
    $ wget https://github.com/lesovsky/pgcenter/releases/download/v0.6.5/pgcenter_0.6.5_Linux_x86_64.tar.gz
    $ tar -zxvf ./pgcenter_0.6.5_Linux_x86_64.tar.gz

# cp /var/lib/pgsql/pgcenter /usr/local/bin
    # which pgcenter
    /usr/local/bin/pgcenter

# 使用 #

# su - postgres
    $ which pgcenter
    /usr/local/bin/pgcenter
    
    $ pgcenter --help
    pgCenter is a command line admin tool for PostgreSQL.
    
    Usage:
      pgcenter [flags]
      pgcenter [command] [command-flags] [args]
    
    Available commands:
      config	configures Postgres to work with pgcenter
      profile	wait events profiler
      record	record stats to file
      report	make report based on previously saved statistics
      top		top-like stats viewer
    
    Flags:
      -?, --help		show this help and exit
          --version		show version information and exit
    
    Use "pgcenter [command] --help" for more information about a command.
    
    Report bugs to https://github.com/lesovsky/pgcenter/issues

需要预先在目标数据库执行一些依赖

yewudb=# create extension plperlu;
    CREATE EXTENSION
    yewudb=# 
    yewudb=# select * from pg_language ;
     lanname  | lanowner | lanispl | lanpltrusted | lanplcallfoid | laninline | lanvalidator | lanacl 
    ----------+----------+---------+--------------+---------------+-----------+--------------+--------
     internal |       10 | f       | f            |             0 |         0 |         2246 | 
     c        |       10 | f       | f            |             0 |         0 |         2247 | 
     sql      |       10 | f       | t            |             0 |         0 |         2248 | 
     plpgsql  |       10 | t       | t            |         13795 |     13796 |        13797 | 
     plperlu  |       10 | t       | f            |        412208 |    412209 |       412210 | 
    (5 rows)

$ pgcenter config -i -d yewudb -U postgres
    
    $ pgcenter top

![在这里插入图片描述][20200918105948907.png_pic_center]

参考:  
https://github.com/lesovsky/pgcenter

[20200918105948907.png_pic_center]: /images/20221123/cae184861aef44e88da59ec81a5bcbfb.png