上一页 1 ··· 9 10 11 12 13 14 15 16 17 ··· 70 下一页
摘要: 1. nginx直接跳转转发 server { listen 443 ssl; server_name erjiyuming.cheerlose.com; ssl_certificate /etc/nginx/ssl/erjiyuming.cheerlose.com/server.pem; ssl_ 阅读全文
posted @ 2021-07-28 10:34 littlevigra 阅读(424) 评论(0) 推荐(0)
摘要: 1. data/base 存放各数据库实例对应文件夹,命名方式是数据库的OID,select oid,datname from pg_database;可以查询每个数据库的OID,对应的可以在base目录下找到这个数据库的文件夹。-- 进入到对应数据库目录: /home/data/base/1066 阅读全文
posted @ 2021-07-21 14:18 littlevigra 阅读(459) 评论(0) 推荐(0)
摘要: 1. WAL writer process把共享内存上的WAL缓存在适当的时间点往磁盘写; 2. 预写式日志WAL(Write Ahead Log,也称为Xlog)的中心思想是对数据文件的修改必须是只能发生在这些修改已经记录到日志之后,也就是先写日志后写数据(日志先行)。 3. 使用这种机制可以避免 阅读全文
posted @ 2021-07-20 23:58 littlevigra 阅读(174) 评论(1) 推荐(0)
摘要: 1. ./configure: error: the HTTP image filter module requires the GD library. You can either do not enable the module or install the libraries. yum ins 阅读全文
posted @ 2021-07-19 13:47 littlevigra 阅读(9434) 评论(0) 推荐(2)
摘要: 1. 参考阿里云文档 :https://help.aliyun.com/document_detail/113316.html?spm=a2c4g.11186623.6.925.3aa35181enfucr 先要在阿里云控制台重启服务器 1.扩容分区 yum install -y cloud-uti 阅读全文
posted @ 2021-07-16 18:04 littlevigra 阅读(105) 评论(2) 推荐(0)
摘要: 1. Install Howto Download latest epel-release rpm from http://download-ib01.fedoraproject.org/pub/epel/7/x86_64/ Install epel-release rpm: # rpm -Uvh 阅读全文
posted @ 2021-07-01 10:16 littlevigra 阅读(712) 评论(0) 推荐(0)
摘要: 1. 查看占io的sql: postgres=# select userid::regrole, dbid, query from pg_stat_statements order by total_time desc limit 5; ERROR: pg_stat_statements must 阅读全文
posted @ 2021-06-24 14:06 littlevigra 阅读(1983) 评论(0) 推荐(0)
摘要: 1. 安装依赖库:yum -y install postgresql-devel yum -y install postgresql-static 2. 下载源码包并解压进入wget http://api.pgxn.org/dist/pg_repack/1.4.5/pg_repack-1.4.5.z 阅读全文
posted @ 2021-06-21 22:30 littlevigra 阅读(643) 评论(0) 推荐(0)
摘要: 1. telegraf的配置 [root@agent-pg135 log]# cat /etc/telegraf/telegraf.conf [global_tags] [agent] interval = "10s" round_interval = true metric_batch_size 阅读全文
posted @ 2021-05-22 17:08 littlevigra 阅读(166) 评论(0) 推荐(0)
摘要: 1. telegraf的redis配置 [root@influxdb137 ~]# cat /etc/telegraf/telegraf.conf [global_tags] [agent] interval = "10s" round_interval = true metric_batch_si 阅读全文
posted @ 2021-05-21 00:11 littlevigra 阅读(703) 评论(0) 推荐(0)
上一页 1 ··· 9 10 11 12 13 14 15 16 17 ··· 70 下一页