可以建立网站的平台,没网站可以做快排吗,自己做的网站怎样对接支付宝,WordPress更新时间文章目录 前言1. 安装备份工具1.1 环境介绍1.2 RPM 安装1.3 验证 2. 配置备份工具2.1 初始化设置2.2 创建备份用户2.3 配置自动归档 3. 工具使用介绍3.1 init3.2 add-instance3.3 del-instance3.4 set-config3.5 show-config3.6 set-backup3.7 backup3.8 show3.9 delete3.10 re… 文章目录 前言1. 安装备份工具1.1 环境介绍1.2 RPM 安装1.3 验证 2. 配置备份工具2.1 初始化设置2.2 创建备份用户2.3 配置自动归档 3. 工具使用介绍3.1 init3.2 add-instance3.3 del-instance3.4 set-config3.5 show-config3.6 set-backup3.7 backup3.8 show3.9 delete3.10 restore3.11 catchup3.12 archive-push3.13 archive-get3.14 checkdb3.15 validate3.16 merge 前言
pg_probackup 是一款功能强大的开源 PostgreSQL 备份工具和 MySQL 社区 XtraBackup 类似本篇文章将和各位共同探索学习。 开源地址 https://github.com/postgrespro/pg_probackup 文档地址 https://postgrespro.github.io/pg_probackup 1. 安装备份工具
1.1 环境介绍
环境介绍CentOS Linux release 7.8.2003 (Core) 数据库版本PostgreSQL - 12.2
1.2 RPM 安装
# RPM Centos Packages
rpm -ivh https://repo.postgrespro.ru/pg_probackup/keys/pg_probackup-repo-centos.noarch.rpm# pg_probackup-这里写 PG 对应的大版本
yum install pg_probackup-{15,14,13,12,11}
yum install pg_probackup-{15,14,13,12,11}-debuginfo官方 Github 有安装说明可以根据环境安装指引安装上面是 CentOS 环境安装方法。
1.3 验证
RPM 安装完成后会自动配置环境变量这里我安装的是 12 版本所以使用 pg_probackup-12 命令操作工具
pg_probackup-12 --help2. 配置备份工具
2.1 初始化设置
初始化备份目录
pg_probackup-12 init -B ${backup_dir}pg_probackup-12 init -B /data/pgsql12/backup INFO: Backup catalog ‘/data/pgsql12/backup’ successfully initialized 添加新的备份实例
# 本地实例
pg_probackup-12 add-instance -B ${backup_dir} -D ${PGDATA} --instance ${instance_name}# 添加远程实例
pg_probackup-12 add-instance -B ${backup_dir} -D ${PGDATA} --instance ${instance_name} --remote-protssh --remote-host${remote_ip} --remote-port${remote_ssh_port} --remote-user${remote_ssh_user} --remote-path${pg_probackup_dir}pg_probackup-12 add-instance -B /data/pgsql12/backup/ -D /data/pgsql12/data/ --instance test01 INFO: Instance ‘test01’ successfully initialized 2.2 创建备份用户
PostgreSQL versions 10 - 14 备份用户创建语句
BEGIN;
CREATE ROLE backup WITH LOGIN;
GRANT USAGE ON SCHEMA pg_catalog TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.current_setting(text) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.set_config(text, text, boolean) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_is_in_recovery() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_start_backup(text, boolean, boolean) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_stop_backup(boolean, boolean) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_create_restore_point(text) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_switch_wal() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_last_wal_replay_lsn() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.txid_current() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.txid_current_snapshot() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.txid_snapshot_xmax(txid_snapshot) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_control_checkpoint() TO backup;
COMMIT;PostgreSQL versions 15 备份用户创建语句
BEGIN;
CREATE ROLE backup WITH LOGIN;
GRANT USAGE ON SCHEMA pg_catalog TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.current_setting(text) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.set_config(text, text, boolean) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_is_in_recovery() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_backup_start(text, boolean) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_backup_stop(boolean) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_create_restore_point(text) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_switch_wal() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_last_wal_replay_lsn() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.txid_current() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.txid_current_snapshot() TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.txid_snapshot_xmax(txid_snapshot) TO backup;
GRANT EXECUTE ON FUNCTION pg_catalog.pg_control_checkpoint() TO backup;
COMMIT;用户创建完成后注意 pg_hba.conf 放开 backup 用户。
2.3 配置自动归档
配置 wal 自动归档需要调整如下参数
# 自动归档的时间单位为秒可酌情设置建议 1 分钟
max_wal_senders 60
# 开启归档
archive_mode on
# WAL 格式归档必须是 replica 及更高级别
wal_level replica
# 配置归档命令
archive_command pg_probackup-12 archive-push -B /data/pgsql12/backup --instance test01 --wal-file-path%p --wal-file-name%f配置完成后需要重启数据库可以使用下方命令查看归档信息
pg_probackup-12 show -B /data/pgsql12/backup --instance test01 --archive3. 工具使用介绍
使用 pg_probackup-12 --help 可以看到该工具主要分为几块功能本小节会详细介绍。
pg_probackup-12 - utility to manage backup/recovery of PostgreSQL database.pg_probackup-12 help [COMMAND]pg_probackup-12 versionpg_probackup-12 init -B backup-pathpg_probackup-12 set-backup -B backup-path --instanceinstance_name-i backup-id [--ttlinterval] [--expire-timetimestamp][--notetext][--help]pg_probackup-12 show-config -B backup-path --instanceinstance_name[--formatformat][--help]....................3.1 init
pg_probackup-12 init -B backup-path初始化备份目录安装完 pg_probackup 需要做的事情这里相当于给 pg_probackup-12 创建一个工作目录管理备份文件和归档文件 pg_probackup 可以用于管理多个实例的备份。
例如
pg_probackup-12 init -B /pg_data/backup将 /pg_data/backup 设置为备份工具的 home 目录。
3.2 add-instance
pg_probackup-12 add-instance -B backup-path -D pgdata-path--instanceinstance_name[--external-dirsexternal-directories-paths][--remote-proto] [--remote-host][--remote-port] [--remote-path] [--remote-user][--ssh-options]添加需要备份的实例信息 pg_probackup 可以管理多个实例的备份可以作为备份管理中心。
添加本地备份实例例如
pg_probackup-12 add-instance -B /pg_data/backup -D /data/pgsql12/data --instance node01将本地数据目录为 /pg_data/backup 的 PostgreSQL 添加到备份管理中心。如果要添加远程备份实例需要先配置互信。
## 在远程备份实例主机上
# su - postgres
$ ssh-keygen
$ ssh-copy-id postgres${备份机_ip}## 在备份机上
# su - postgres
$ ssh-keygen
$ ssh-copy-id postgres${备份实例主机_ip}## 测试互信
$ ssh postgres${对方IP}添加远程实例
pg_probackup-12 add-instance -B /data/pgsql12/backup -D /data/pgsql/data --instance test02 --remote-protssh --remote-host172.16.104.55 --remote-port22 --remote-userpostgresINFO: Instance ‘test02’ successfully initialized 3.3 del-instance
pg_probackup-12 del-instance -B backup-path--instanceinstance_name[--help]从备份元数据中心里删除实例信息。例如
pg_probackup-12 del-instance -B /data/pgsql12/backup/ --instance test02INFO: Delete: RZXNFS 2023-08-25 14:02:1608 INFO: Delete: RZXNEX 2023-08-25 14:01:4508 INFO: Delete: RZXND9 2023-08-25 14:00:4508 INFO: Delete: RZXNCL 2023-08-25 14:00:2108 INFO: Delete: RZXNA5 2023-08-25 13:58:5308 INFO: Delete: RZXN9V 2023-08-25 13:58:4308 INFO: Instance ‘test02’ successfully deleted 3.4 set-config
pg_probackup-12 set-config -B backup-path --instanceinstance_name[-D pgdata-path][--external-dirsexternal-directories-paths][--log-level-consolelog-level-console][--log-level-filelog-level-file][--log-format-filelog-format-file][--log-filenamelog-filename][--error-log-filenameerror-log-filename][--log-directorylog-directory][--log-rotation-sizelog-rotation-size][--log-rotation-agelog-rotation-age][--retention-redundancyretention-redundancy][--retention-windowretention-window][--wal-depthwal-depth][--compress-algorithmcompress-algorithm][--compress-levelcompress-level][--archive-timeouttimeout][-d dbname] [-h host] [-p port] [-U username][--remote-proto] [--remote-host][--remote-port] [--remote-path] [--remote-user][--ssh-options][--restore-commandcmdline] [--archive-hostdestination][--archive-portport] [--archive-userusername][--help]可以配置备份保留策略及一些配置参数例如配置备份保留策略
pg_probackup-12 set-config -B /pg_data/backup --instance node01 --retention-redundancy 7 --retention-window 73.5 show-config
pg_probackup-12 show-config -B backup-path --instanceinstance_name[--formatformat][--help]查看备份服务的参数配置信息。
3.6 set-backup
pg_probackup-12 set-backup -B backup-path --instanceinstance_name-i backup-id [--ttlinterval] [--expire-timetimestamp][--notetext][--help]修改备份文件的元数据信息。
3.7 backup
pg_probackup-12 backup -B backup-path -b backup-mode --instanceinstance_name[-D pgdata-path] [-C][--stream [-S slot-name] [--temp-slot]][--backup-pg-log] [-j num-threads] [--progress][--no-validate] [--skip-block-validation][--external-dirsexternal-directories-paths][--no-sync][--log-level-consolelog-level-console][--log-level-filelog-level-file][--log-format-consolelog-format-console][--log-format-filelog-format-file][--log-filenamelog-filename][--error-log-filenameerror-log-filename][--log-directorylog-directory][--log-rotation-sizelog-rotation-size][--log-rotation-agelog-rotation-age] [--no-color][--delete-expired] [--delete-wal] [--merge-expired][--retention-redundancyretention-redundancy][--retention-windowretention-window][--wal-depthwal-depth][--compress][--compress-algorithmcompress-algorithm][--compress-levelcompress-level][--archive-timeoutarchive-timeout][-d dbname] [-h host] [-p port] [-U username][-w --no-password] [-W --password][--remote-proto] [--remote-host][--remote-port] [--remote-path] [--remote-user][--ssh-options][--ttlinterval] [--expire-timetimestamp] [--notetext][--help]启动备份的方法下面详细介绍该功能参数
-B, --backup-pathbackup-path备份工具 init 的目录。-b, --backup-modebackup-mode备份的模式有 FULL、PAGE、DELTA、PTRACK 四种模式。 FULL创建一个完整备份其中包含要恢复的集群的所有数据文件。PAGE根据自上次完整或增量备份以来生成的 WAL 文件创建增量备份。仅从数据文件中读取更改的块。DELTA读取数据目录中的所有数据文件并为自上次备份以来已更改的页面创建增量备份。PTRACK动态创建增量备份跟踪页面更改。 -C, --smooth-checkpoint将检查点分散在一段时间内。默认情况下 pg_probackup 尝试尽快完成检查点。–instanceinstance_name实例名通过指定实例名备份工具会根据元数据查到该实例的信息。–stream如果在备份命令中加入该参数表示使用流模式备份 WAL 日志。-S, --slotSLOTNAME指定 WAL 流的复制槽。该选项只能与 --stream 标志一起使用。-j, --threadsNUM并发几个线程来进行备份。
使用案例在本地发起备份
pg_probackup-12 backup -B /data/pgsql12/backup/ --instance test01 -b fullINFO: Database backup start INFO: wait for pg_start_backup() INFO: Wait for WAL segment /data/pgsql12/backup/wal/test01/00000002000000020000007E to be archived INFO: PGDATA size: 2397MB INFO: Current Start LSN: 2/7E000028, TLI: 2 INFO: Start transferring data files INFO: Data files are transferred, time elapsed: 39s INFO: wait for pg_stop_backup() INFO: pg_stop backup() successfully executed INFO: stop_lsn: 2/7F0000F0 INFO: Getting the Recovery Time from WAL INFO: Syncing backup files to disk INFO: Backup files are synced, time elapsed: 1s INFO: Validating backup RZXNYO INFO: Backup RZXNYO data files are valid INFO: Backup RZXNYO resident size: 2400MB INFO: Backup RZXNYO completed 使用案例发起远程备份
pg_probackup-12 backup -B /data/pg_backup --instance test02 --remote-userpostgres --remote-host172.16.104.7 --remote-protossh --stream --remote-port22 -b fullINFO: Database backup start INFO: wait for pg_start_backup() INFO: Wait for WAL segment /data/pg_backup/backups/test02/S04Q23/database/pg_wal/000000020000000200000092 to be streamed INFO: PGDATA size: 2405MB INFO: Current Start LSN: 2/92000028, TLI: 2 INFO: Start transferring data files INFO: Data files are transferred, time elapsed: 40s INFO: wait for pg_stop_backup() INFO: pg_stop backup() successfully executed INFO: stop_lsn: 2/920001A0 INFO: Getting the Recovery Time from WAL INFO: Syncing backup files to disk INFO: Backup files are synced, time elapsed: 1s INFO: Validating backup S04Q23 INFO: Backup S04Q23 data files are valid INFO: Backup S04Q23 resident size: 2439MB INFO: Backup S04Q23 completed 接下来测试增量备份
# 先发起一个物理全量备份
pg_probackup-12 backup -B /pg_data/backup --instance node01 -b full查看备份信息
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
node01 12 S0GD3F 2023-09-04 16:33:5708 FULL ARCHIVE 3/0 44s 2446MB 16MB 1.00 4/E9000028 4/EA000128 OK 测试制造数据变动
update pgbench_accounts set bid 6;基于上次的全备进行增量备份
pg_probackup-12 backup -B /pg_data/backup --instance node01 -b pageInstance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
node01 12 S0GDJI 2023-09-04 16:43:2408 PAGE ARCHIVE 3/3 31s 1090MB 16MB 1.00 5/6D000110 5/6E0000F0 OK node01 12 S0GD3F 2023-09-04 16:33:5708 FULL ARCHIVE 3/0 44s 2446MB 16MB 1.00 4/E9000028 4/EA000128 OK 3.8 show
pg_probackup-12 show -B backup-path[--instanceinstance_name [-i backup-id]][--formatformat] [--archive][--no-color] [--help]该方法用于查看备份列表信息和归档信息。使用案例查看备份信息
pg_probackup-12 show -B /data/pg_backup/BACKUP INSTANCE test02
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
test02 12 S04Q23 2023-08-29 09:42:5008 FULL STREAM 2/0 54s 2407MB 32MB 1.00 2/92000028 2/920001A0 OK 使用案例查看归档信息
pg_probackup-12 show -B /data/pgsql12/backup/ --archiveARCHIVE INSTANCE test01
TLI Parent TLI Switchpoint Min Segno Max Segno N segments Size Zratio N backups Status
2 0 0/0 000000020000000200000072 000000020000000200000092 32 512MB 1.00 0 DEGRADED 3.9 delete pg_probackup-12 delete -B backup-path --instanceinstance_name[-j num-threads] [--progress][--retention-redundancyretention-redundancy][--retention-windowretention-window][--wal-depthwal-depth][-i backup-id | --delete-expired | --merge-expired | --statusbackup_status][--delete-wal][--dry-run] [--no-validate] [--no-sync][--help]该方法用于删除备份或删除过期的归档日志。例如
pg_probackup-12 delete -B /pg_data/backup/ --instance node01 -i S0G7IN
# INFO: Delete: S0G7IN 2023-09-04 14:32:4708删除过期的备份和 WAL 日志
pg_probackup-12 delete -B /pg_data/backup --instance node01 --delete-expired --delete-wal3.10 restore
pg_probackup-12 restore -B backup-path --instanceinstance_name[-D pgdata-path] [-i backup-id] [-j num-threads][--recovery-target-timetime|--recovery-target-xidxid|--recovery-target-lsnlsn [--recovery-target-inclusiveboolean]][--recovery-target-timelinetimeline][--recovery-targetimmediate|latest][--recovery-target-nametarget-name][--recovery-target-actionpause|promote|shutdown][--restore-commandcmdline][-R | --restore-as-replica] [--force][--primary-conninfoprimary_conninfo][-S | --primary-slot-nameslotname][--no-validate] [--skip-block-validation][-T OLDDIRNEWDIR] [--progress][--external-mappingOLDDIRNEWDIR][--skip-external-dirs] [--no-sync][-X WALDIR | --waldirWALDIR][-I | --incremental-modenone|checksum|lsn][--db-include | --db-exclude][--remote-proto] [--remote-host][--remote-port] [--remote-path] [--remote-user][--ssh-options][--archive-hosthostname][--archive-portport] [--archive-userusername][--help]该方法用于将备份恢复到新的 PostgreSQL 实例如果指定恢复目标参数pg_probackup 会查找最近的备份并将其恢复到指定的恢复目标如果没有提供备份 ID 也没有提供恢复目标选项 pg_probackup 使用最新的备份来执行恢复。
全量备份恢复案例
# 停掉 PostgreSQL
pg_ctl -D /data/pgsql12/data/ -l /data/pgsql12/logs/start.log stop# 删掉数据目录
rm -rf /data/pgsql12/data# 使用备份恢复这里用的是远程备份恢复
pg_probackup-12 restore -B /data/pg_backup --instance test02 --remote-userpostgres --remote-host172.16.104.7 --remote-protossh --stream --remote-port22# 使用备份恢复这里是本地备份
pg_probackup-12 restore -B /data/pgsql12/backup/ --instance test01 -i S08V98# 恢复后启动 PostgreSQL
pg_ctl -D /data/pgsql12/data/ -l /data/pgsql12/logs/start.log startINFO: Validating backup S04Q23 INFO: Backup S04Q23 data files are valid INFO: Backup S04Q23 WAL segments are valid INFO: Backup S04Q23 is valid. INFO: Restoring the database from backup at 2023-08-29 09:42:0308 INFO: Start restoring backup files. PGDATA size: 2437MB INFO: Backup files are restored. Transfered bytes: 2437MB, time elapsed: 52s INFO: Restore incremental ratio (less is better): 100% (2437MB/2437MB) INFO: Syncing restored files to disk INFO: Restored backup files are synced, time elapsed: 3s INFO: Restore of backup S04Q23 completed. 3.11 catchup
pg_probackup-12 catchup -b catchup-mode--source-pgdatapath_to_pgdata_on_remote_server--destination-pgdatapath_to_local_dir[--stream [-S slot-name] [--temp-slot | --perm-slot]][-j num-threads][-T OLDDIRNEWDIR][--exclude-pathpath_prefix][-d dbname] [-h host] [-p port] [-U username][-w --no-password] [-W --password][--remote-proto] [--remote-host][--remote-port] [--remote-path] [--remote-user][--ssh-options][--dry-run][--help]3.12 archive-push
pg_probackup-12 archive-push -B backup-path --instanceinstance_name--wal-file-namewal-file-name[--wal-file-pathwal-file-path][-j num-threads] [--batch-sizebatch_size][--archive-timeouttimeout][--no-ready-rename] [--no-sync][--overwrite] [--compress][--compress-algorithmcompress-algorithm][--compress-levelcompress-level][--remote-proto] [--remote-host][--remote-port] [--remote-path] [--remote-user][--ssh-options][--help]该方法用于备份归档文件 可将该命令添加到 PostgreSQL 参数文件中。
# 自动归档的时间单位为秒可酌情设置建议 1 分钟
max_wal_senders 60
# 开启归档
archive_mode on
# WAL 格式归档必须是 replica 及更高级别
wal_level replica
# 配置归档命令
archive_command pg_probackup-12 archive-push -B /data/pgsql12/backup --instance test01 --wal-file-path%p --wal-file-name%f3.13 archive-get
pg_probackup-12 archive-get -B backup-path --instanceinstance_name--wal-file-pathwal-file-path--wal-file-namewal-file-name[-j num-threads] [--batch-sizebatch_size][--no-validate-wal][--remote-proto] [--remote-host][--remote-port] [--remote-path] [--remote-user][--ssh-options][--help]该方法用于将 WAL 文件从备份目录拷贝到 PostgreSQL WAL 日志目录用于 PITR。该命令由 pg_probackup 自动设置 Restore_command 用户可不用关心如何设置。
3.14 checkdb
pg_probackup-12 checkdb [-B backup-path] [--instanceinstance_name][-D pgdata-path] [--progress] [-j num-threads][--amcheck] [--skip-block-validation][--heapallindexed] [--checkunique][--help]通过检测物理和逻辑损坏来验证 PostgreSQL 数据库集群的正确性。
3.15 validate
pg_probackup-12 validate -B backup-path [--instanceinstance_name][-i backup-id] [--progress] [-j num-threads][--recovery-target-timetime|--recovery-target-xidxid|--recovery-target-lsnlsn [--recovery-target-inclusiveboolean]][--recovery-target-timelinetimeline][--recovery-target-nametarget-name][--skip-block-validation][--help]该方法用于验证备份的正确性。使用案例验证 test02 实例编号为 S04Q23 的备份。
pg_probackup-12 validate -B /data/pg_backup -i S04Q23 --instance test02INFO: Validating backup S04Q23 INFO: Backup S04Q23 data files are valid INFO: Backup S04Q23 WAL segments are valid INFO: Backup S04Q23 is valid. INFO: Validate of backup S04Q23 completed. 3.16 merge
pg_probackup-12 merge -B backup-path --instanceinstance_name-i backup-id [--progress] [-j num-threads][--no-validate] [--no-sync][--help]该方法用于合并增量备份合并备份文件。 文章转载自： http://www.morning.jgcyn.cn.gov.cn.jgcyn.cn http://www.morning.uqrphxm.cn.gov.cn.uqrphxm.cn http://www.morning.kqwsy.cn.gov.cn.kqwsy.cn http://www.morning.fpzz1.cn.gov.cn.fpzz1.cn http://www.morning.nfdty.cn.gov.cn.nfdty.cn http://www.morning.drbd.cn.gov.cn.drbd.cn http://www.morning.rfgc.cn.gov.cn.rfgc.cn http://www.morning.fkdts.cn.gov.cn.fkdts.cn http://www.morning.xpqsk.cn.gov.cn.xpqsk.cn http://www.morning.lbggk.cn.gov.cn.lbggk.cn http://www.morning.wzjhl.cn.gov.cn.wzjhl.cn http://www.morning.jbmsp.cn.gov.cn.jbmsp.cn http://www.morning.sjqpm.cn.gov.cn.sjqpm.cn http://www.morning.lskyz.cn.gov.cn.lskyz.cn http://www.morning.fgwzl.cn.gov.cn.fgwzl.cn http://www.morning.wpqwk.cn.gov.cn.wpqwk.cn http://www.morning.qykxj.cn.gov.cn.qykxj.cn http://www.morning.nnqrb.cn.gov.cn.nnqrb.cn http://www.morning.jtmql.cn.gov.cn.jtmql.cn http://www.morning.xbtlt.cn.gov.cn.xbtlt.cn http://www.morning.mlcnh.cn.gov.cn.mlcnh.cn http://www.morning.xpwdf.cn.gov.cn.xpwdf.cn http://www.morning.czzpm.cn.gov.cn.czzpm.cn http://www.morning.pdmml.cn.gov.cn.pdmml.cn http://www.morning.jgmlb.cn.gov.cn.jgmlb.cn http://www.morning.rshijie.com.gov.cn.rshijie.com http://www.morning.xlbtz.cn.gov.cn.xlbtz.cn http://www.morning.wchcx.cn.gov.cn.wchcx.cn http://www.morning.slkqd.cn.gov.cn.slkqd.cn http://www.morning.rfxw.cn.gov.cn.rfxw.cn http://www.morning.lddpj.cn.gov.cn.lddpj.cn http://www.morning.htbsk.cn.gov.cn.htbsk.cn http://www.morning.dmfdl.cn.gov.cn.dmfdl.cn http://www.morning.yrgb.cn.gov.cn.yrgb.cn http://www.morning.wqmpd.cn.gov.cn.wqmpd.cn http://www.morning.wspyb.cn.gov.cn.wspyb.cn http://www.morning.kpfds.cn.gov.cn.kpfds.cn http://www.morning.xkhhy.cn.gov.cn.xkhhy.cn http://www.morning.mbrbk.cn.gov.cn.mbrbk.cn http://www.morning.sbyhj.cn.gov.cn.sbyhj.cn http://www.morning.rwyd.cn.gov.cn.rwyd.cn http://www.morning.rzcbk.cn.gov.cn.rzcbk.cn http://www.morning.tkryt.cn.gov.cn.tkryt.cn http://www.morning.wbyqy.cn.gov.cn.wbyqy.cn http://www.morning.rqjl.cn.gov.cn.rqjl.cn http://www.morning.xlbyx.cn.gov.cn.xlbyx.cn http://www.morning.yfrbn.cn.gov.cn.yfrbn.cn http://www.morning.rtryr.cn.gov.cn.rtryr.cn http://www.morning.xbrxk.cn.gov.cn.xbrxk.cn http://www.morning.sjftk.cn.gov.cn.sjftk.cn http://www.morning.gsdbg.cn.gov.cn.gsdbg.cn http://www.morning.glnmm.cn.gov.cn.glnmm.cn http://www.morning.bqmdl.cn.gov.cn.bqmdl.cn http://www.morning.lmhh.cn.gov.cn.lmhh.cn http://www.morning.dmwjl.cn.gov.cn.dmwjl.cn http://www.morning.npfkw.cn.gov.cn.npfkw.cn http://www.morning.lrprj.cn.gov.cn.lrprj.cn http://www.morning.wfhnz.cn.gov.cn.wfhnz.cn http://www.morning.bttph.cn.gov.cn.bttph.cn http://www.morning.lsnhs.cn.gov.cn.lsnhs.cn http://www.morning.kxwsn.cn.gov.cn.kxwsn.cn http://www.morning.lbcbq.cn.gov.cn.lbcbq.cn http://www.morning.jftl.cn.gov.cn.jftl.cn http://www.morning.yngtl.cn.gov.cn.yngtl.cn http://www.morning.sfrw.cn.gov.cn.sfrw.cn http://www.morning.xtxp.cn.gov.cn.xtxp.cn http://www.morning.qzpqp.cn.gov.cn.qzpqp.cn http://www.morning.jmlgk.cn.gov.cn.jmlgk.cn http://www.morning.kstgt.cn.gov.cn.kstgt.cn http://www.morning.jpfpc.cn.gov.cn.jpfpc.cn http://www.morning.cnqff.cn.gov.cn.cnqff.cn http://www.morning.bwnd.cn.gov.cn.bwnd.cn http://www.morning.kxgn.cn.gov.cn.kxgn.cn http://www.morning.lmjkn.cn.gov.cn.lmjkn.cn http://www.morning.lxngn.cn.gov.cn.lxngn.cn http://www.morning.bhpjc.cn.gov.cn.bhpjc.cn http://www.morning.smj78.cn.gov.cn.smj78.cn http://www.morning.fqhbt.cn.gov.cn.fqhbt.cn http://www.morning.nbnq.cn.gov.cn.nbnq.cn http://www.morning.fxpyt.cn.gov.cn.fxpyt.cn
