企业官网建设流程全解析

罗湖做网站联系电话,网站都是每年续费的吗,seo诊断大夫,wordpress 价格文章目录 文档用途详细信息 文档用途 Highgo Database数据库清理流复制节点详细配置过程 详细信息 关闭数据库并备份 主库#xff1a; [highgolocalhost 4.1]$ cp -rp data data.bak_180122 [highgolocalhost 4.1]$ du -sh * 221G data 221G data.bak_180122 备库[highgolocalhost 4.1]$ cp -rp data data.bak_180122[highgolocalhost 4.1]$ du -sh *221G data221G data.bak_180122备库[highgolocalhost 4.1]$ cp -rp data data.bak_180122[highgolocalhost 4.1]$ du -sh *91G data91G data.bak_180122修改参数243\236\237\238cd $PGDATAsed -i ‘$ s/on/off/g’ postgresql.auto.confcat postgresql.auto.conf | grep hot_standby_feedback25.21\22\23\24cd $PGDATAsed -i $ a hot_standby_feedback ‘off’ postgresql.auto.confcat postgresql.auto.conf | grep hot_standby_feedback关闭流复制wal_level archivemax_wal_senders ‘0’hot_standby ‘off’清理数据库[highgolocalhost base]$ du -sh * 查看每个数据库实际的大小7.3M 17.3M 133457.5M 1335039M 1704211G 1765278G 186578.0M 2748712K pgsql_tmp连接到主备数据库进行清理\c highgo_alter_logvacuum FULL;清理过程中可以查询当前锁住的事物select locktype,relation::regclass as re1,virtualxid as vxid,transactionid as xid,virtualtransaction as vxid2,pid,mode,grantedfrom pg_locks;清理成功[highgolocalhost base]$ du -sh *7.5M 17.3M 133456.6M 1335039M 1704211G 1765278G 186578.0M 2748712K pgsql_tmp数据库对应的OID[highgolocalhost base]$ oid2nameAll databases:Oid Database Name Tablespace -------------------------------------- 18657 highgo pg_default 27487 highgo_alter_log pg_default 17652 highgo_presure pg_default 17042 highgo_test pg_default 13350 highgo pg_default 13345 template0 pg_default template1 pg_default清理已经废弃的节点信息alter system set synchronous_standby_names ‘sync243,sync236,sync237,sync238, sync21, sync22, sync23, sync24’select pg_reload_conf();删除复制槽pg_drop_replication_slot(‘10.243.25.241’);注意如果不删除复制槽的话已经产生的“错误”WAL日志不会释放highgo# select pid,state,client_addr,sync_priority,sync_state from pg_stat_replication;pid | state | client_addr | sync_priority | sync_state-------±----------±--------------±--------------±-----------8340 | streaming | 10.243.25.23 | 7 | potential8341 | streaming | 10.254.23.243 | 1 | sync8342 | streaming | 10.243.25.24 | 8 | potential26779 | streaming | 10.254.23.237 | 3 | potential8344 | streaming | 10.243.25.21 | 5 | potential8345 | streaming | 10.254.23.236 | 2 | potential8346 | streaming | 10.243.25.22 | 6 | potential8347 | streaming | 10.254.23.238 | 4 | potential查看清理后的状态[highgolocalhost pg_xlog]$ du -sh514M .[highgolocalhost pg_xlog]$ pwd/data/highgo/4.1/data/pg_xlog[highgolocalhost pg_xlog]$ ls -l|grep “^-”| wc -l33[highgolocalhost pg_xlog]$ df -hFilesystem Size Used Avail Use% Mounted on/dev/mapper/centos-root 50G 2.8G 48G 6% /devtmpfs 16G 0 16G 0% /devtmpfs 16G 4.0K 16G 1% /dev/shmtmpfs 16G 97M 16G 1% /runtmpfs 16G 0 16G 0% /sys/fs/cgroup/dev/sda1 497M 109M 389M 22% /boot/dev/sdb1 2.0T 94G 1.8T 6% /data/dev/mapper/centos-home 42G 35M 42G 1% /hometmpfs 3.2G 0 3.2G 0% /run/user/5866