shell 脚本连接 postgresql 数据库

规划192.168.56.11k1192.168.56.12k2192.168.56.13k3192.168.56.21pg11n1192.168.56.22pg11n2主机 pg11n1 、pg11n2上安装 postgresql 11安装 yum 源# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/E

os: centos 7.6es: 7.6现有集群包含节点 n1、n2、n3(master + data)，可以通过添加 n4 节点(data)，来实现数据的打散。版本# cat /etc/centos-releaseCentOS Linux release 7.6.1810 (Core)# yum list installed |grep -i elasticsearchelasticsearc

os: centos 7.6db: postgres 12.7zabbix: 5.0 LTS登录 http://192.168.56.11:8080 时，用户 Admin 忘记密码。处理过程如下# su - postgres$ psqlpostgres=# \lList of databasesName|Owner| Encoding |Collate|Ctype

os: centos 7.6.1810es: elasticsearch Version 7.12.0 (Build 778cc7261dfdd1)使用 rpm 方式安装的 elasticsearch ()# ls -l-rw-r--r--1 root root 327593346 Apr 15 13:18 elasticsearch-7.12.0-x86_64.rpm# cat /usr/lib

./runcluvfy.sh stage -pre crsinst -n node1,node2 -verboseVerifying RPM Package Manager database ...INFORMATIONPRVG-11250 : The check "RPM Package Manager database" was not performed becauseit needs 'r

create tableSQL> create table tmp_t0(idinteger,name varchar2(100),memo varchar2(100));SQL> insert into tmp_t0select level,sys_guid() as name,sys_guid() as memofrom dualconnect by level <=1000

os: centos 7.4db: oracle 11.2.0.4版本# cat /etc/centos-releaseCentOS Linux release 7.4.1708 (Core)## su - oracleLast login: Tue Jan 21 03:40:05 CST 2020 on pts/0$ sqlplus / as sysdba;SQL*Plus: Release 1

os: centos 7.4db: postgresql 10.11Nested Loop 比较适合两个表的数据量都比较少的情况(最简单的 table join 方式)外层驱动表过滤后的数据量较少。内层被驱动表的关联列上最好有高效索引(主键或者唯一性索引)。版本# cat /etc/centos-releaseCentOS Linux release 7.4.1708 (Core)## su -

https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/postgresql