![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
文章平均质量分 80
TOMSER123
坚持就是胜利!
展开
-
PostgreSQL 11.5源码安装
PostgreSQL 11源码安装PostgreSQL 11安装方式一样测试环境:RedHat 7.2 Linux 64bitPostgreSQL 11.5源码安装包下载,下载地址:https://www.postgresql.org/ftp/source/系统环境准备需要安装PostgreSQL编译依赖包,如下:yum -y install gcc bison gcc-c++ readline readline-devel zlib zlib-devel perl perl-de原创 2021-10-13 09:05:59 · 488 阅读 · 0 评论 -
Postgres 数据库日常维护SQL
1、查数据库的活动连接select datname,procpid,query_start,current_query,waiting,client_addr from pg_stat_activity order by datname;--查看所有系统视图select relkind,relname from pg_class where relnamespace = (select oid from pg_namespace where nspname='pg_catalog') and rel原创 2020-07-22 20:22:46 · 425 阅读 · 0 评论