hgdb流复制备库提升为主库
来源:互联网 发布:计算流体力学 知乎 编辑:程序博客网 时间:2024/06/01 12:40
[highgo@hg data]$ pg_controldata
pg_control version number: 942
Catalog version number: 201409291
Database system identifier: 6407613912621653765
Database cluster state: in archive recovery **************************************
pg_control last modified: Fri 19 May 2017 11:37:40 AM CST
Latest checkpoint location: 0/27000028
Prior checkpoint location: 0/27000028
Latest checkpoint's REDO location: 0/27000028
Latest checkpoint's REDO WAL file: 000000010000000000000027
Latest checkpoint's TimeLineID: 1
Latest checkpoint's PrevTimeLineID: 1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 0/1854
Latest checkpoint's NextOID: 16410
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 1802
Latest checkpoint's oldestXID's DB: 1
Latest checkpoint's oldestActiveXID: 0
Latest checkpoint's oldestMultiXid: 1
Latest checkpoint's oldestMulti's DB: 1
Time of latest checkpoint: Fri 19 May 2017 11:37:15 AM CST
Fake LSN counter for unlogged rels: 0/1
Minimum recovery ending location: 0/27000228
Min recovery ending loc's timeline: 1
Backup start location: 0/0
Backup end location: 0/0
End-of-backup record required: no
Current wal_level setting: hot_standby
Current wal_log_hints setting: off
Current max_connections setting: 200
Current max_worker_processes setting: 8
Current max_prepared_xacts setting: 0
Current max_locks_per_xact setting: 64
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Size of a large-object chunk: 2048
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Data page checksum version: 0
[highgo@hg data]$ pg_ctl promote ******************************************************
server promoting
[highgo@hg data]$ pg_controldata
pg_control version number: 942
Catalog version number: 201409291
Database system identifier: 6407613912621653765
Database cluster state: in production ************************************************************
pg_control last modified: Fri 19 May 2017 11:44:56 AM CST
Latest checkpoint location: 0/280000F8
Prior checkpoint location: 0/28000028
Latest checkpoint's REDO location: 0/280000C0
Latest checkpoint's REDO WAL file: 000000020000000000000028
Latest checkpoint's TimeLineID: 2
Latest checkpoint's PrevTimeLineID: 2
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 0/1855
Latest checkpoint's NextOID: 16410
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 1802
Latest checkpoint's oldestXID's DB: 1
Latest checkpoint's oldestActiveXID: 1855
Latest checkpoint's oldestMultiXid: 1
Latest checkpoint's oldestMulti's DB: 1
Time of latest checkpoint: Fri 19 May 2017 11:44:56 AM CST
Fake LSN counter for unlogged rels: 0/1
Minimum recovery ending location: 0/0
Min recovery ending loc's timeline: 0
Backup start location: 0/0
Backup end location: 0/0
End-of-backup record required: no
Current wal_level setting: hot_standby
Current wal_log_hints setting: off
Current max_connections setting: 200
Current max_worker_processes setting: 8
Current max_prepared_xacts setting: 0
Current max_locks_per_xact setting: 64
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Size of a large-object chunk: 2048
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Data page checksum version: 0
[highgo@hg data]$
pg_control version number: 942
Catalog version number: 201409291
Database system identifier: 6407613912621653765
Database cluster state: in archive recovery **************************************
pg_control last modified: Fri 19 May 2017 11:37:40 AM CST
Latest checkpoint location: 0/27000028
Prior checkpoint location: 0/27000028
Latest checkpoint's REDO location: 0/27000028
Latest checkpoint's REDO WAL file: 000000010000000000000027
Latest checkpoint's TimeLineID: 1
Latest checkpoint's PrevTimeLineID: 1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 0/1854
Latest checkpoint's NextOID: 16410
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 1802
Latest checkpoint's oldestXID's DB: 1
Latest checkpoint's oldestActiveXID: 0
Latest checkpoint's oldestMultiXid: 1
Latest checkpoint's oldestMulti's DB: 1
Time of latest checkpoint: Fri 19 May 2017 11:37:15 AM CST
Fake LSN counter for unlogged rels: 0/1
Minimum recovery ending location: 0/27000228
Min recovery ending loc's timeline: 1
Backup start location: 0/0
Backup end location: 0/0
End-of-backup record required: no
Current wal_level setting: hot_standby
Current wal_log_hints setting: off
Current max_connections setting: 200
Current max_worker_processes setting: 8
Current max_prepared_xacts setting: 0
Current max_locks_per_xact setting: 64
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Size of a large-object chunk: 2048
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Data page checksum version: 0
[highgo@hg data]$ pg_ctl promote ******************************************************
server promoting
[highgo@hg data]$ pg_controldata
pg_control version number: 942
Catalog version number: 201409291
Database system identifier: 6407613912621653765
Database cluster state: in production ************************************************************
pg_control last modified: Fri 19 May 2017 11:44:56 AM CST
Latest checkpoint location: 0/280000F8
Prior checkpoint location: 0/28000028
Latest checkpoint's REDO location: 0/280000C0
Latest checkpoint's REDO WAL file: 000000020000000000000028
Latest checkpoint's TimeLineID: 2
Latest checkpoint's PrevTimeLineID: 2
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 0/1855
Latest checkpoint's NextOID: 16410
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 1802
Latest checkpoint's oldestXID's DB: 1
Latest checkpoint's oldestActiveXID: 1855
Latest checkpoint's oldestMultiXid: 1
Latest checkpoint's oldestMulti's DB: 1
Time of latest checkpoint: Fri 19 May 2017 11:44:56 AM CST
Fake LSN counter for unlogged rels: 0/1
Minimum recovery ending location: 0/0
Min recovery ending loc's timeline: 0
Backup start location: 0/0
Backup end location: 0/0
End-of-backup record required: no
Current wal_level setting: hot_standby
Current wal_log_hints setting: off
Current max_connections setting: 200
Current max_worker_processes setting: 8
Current max_prepared_xacts setting: 0
Current max_locks_per_xact setting: 64
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Size of a large-object chunk: 2048
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Data page checksum version: 0
[highgo@hg data]$
阅读全文
0 0
- hgdb流复制备库提升为主库
- HGDB 流复制一主两备切换注意事项
- pgpool流复制两端都是备端,无法认证为主端
- HGDB双机热备
- 额外域控提升为主域控
- android studio 导入项目作为主工程依赖库
- windows server 2008额外域控提升为主域控
- Oracle的高级复制、流复制、备库的区别
- HGDB不知道数据库用户密码的情况下,新库使用原密码创建该用户(适用于postgres)
- 对象的复制,提升整洁度
- redis可靠性提升(主从复制)
- Linux删除HGDB快捷方式
- HGDB-pgbouncer配置
- HGDB pg_xlog个数
- pg(HGDB)学习总结
- activemq持久化配置,设置为主从模式(带复制的主从模式,应用mysql数据库)
- cocos2d-x3.0基础数学知识(为防伸手党,复制粘贴,以图片为主,还是一字一码的敲下吧^_^!)
- 跨库复制数据
- Java jdk 快速配置
- if选择结构和while循环及for循环
- Samba共享服务——实现Linux(ubuntu)与Windows共享文件
- Android随笔:单元测试的好处
- 程序13
- hgdb流复制备库提升为主库
- 词向量源码解析:(3.6)GloVe源码解析小结
- 归并排序 Java实现
- MFC学习笔记-CFile、CFileFind、CArchive
- Guides-旅游类App原型分享
- 程序14
- 阿里云经典网络与Rancher VXLAN兼容性问题
- Button和input button的区别,记我一次坑爹的Bug
- <c:choose>和<fmt:formatDate>的用法