PostgreSQL
文章平均质量分 56
ylqmf
这个作者很懒,什么都没留下…
展开
-
PostgreSQL basebackup备份
#!/bin/shlst=(127.0.0.1:5432:xm_rep:123456127.0.0.1:5432:xm_rep:123456)for item in ${lst[@]}do host=$(echo ${item} | awk -F':' '{print $1}') port=$(echo ${item} | awk -F':' '{p原创 2016-11-30 18:07:40 · 846 阅读 · 0 评论 -
postgresql 定时vacuum脚本
# -*- coding: utf-8 -*-import pg,multiprocessinglst=[{"dbname":"postgres","host":"127.0.01","port":5432,"user":"postgres","passwd":"123456"},]def exe_job(item): try: db = pg.DB(dbn原创 2017-08-02 20:30:39 · 1841 阅读 · 1 评论