这篇文章主要讲解了“PostgreSQL的pg_promote有什么作用”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“PostgreSQL的pg_promote有什么作用”吧！

在PG 12以前的版本,备库提升为主库需在备库主机上执行命令或者通过生成触发文件进行触发,在PG 12中,可通过客户端连接到数据库后执行pg_promote函数实现.

下面以一个简单的例子进行说明.

搭建流复制环境
参照PostgreSQL DBA(31) - Backup&Recovery#4(搭建流复制),注意在PG 12,recovery.conf文件已废弃,相关的配置信息已合并至postgresql.conf文件中.
下面是搭建完毕后,在主库创建数据表t1后,备库的情况.
备库

[pg12@localhostpg12db1]$pg_ctlstartwaitingforservertostart....2019-06-2017:04:04.361CST[23158]LOG:startingPostgreSQL12beta1onx86_64-pc-linux-gnu,compiledbygcc(GCC)4.8.520150623(RedHat4.8.5-16),64-bit2019-06-2017:04:04.362CST[23158]LOG:listeningonIPv4address"0.0.0.0",port54322019-06-2017:04:04.362CST[23158]LOG:listeningonIPv6address"::",port54322019-06-2017:04:04.365CST[23158]LOG:listeningonUnixsocket"/tmp/.s.PGSQL.5432"2019-06-2017:04:04.422CST[23158]LOG:redirectinglogoutputtologgingcollectorprocess2019-06-2017:04:04.422CST[23158]HINT:Futurelogoutputwillappearindirectory"pg_log".doneserverstarted[pg12@localhostpg12db1]$psql-dtestdbpsql(12beta1)Type"help"forhelp.testdb=#selectcount(*)fromt1;psql:ERROR:relation"t1"doesnotexistLINE1:selectcount(*)fromt1;^testdb=#selectcount(*)fromt1;count-------0(1row)

下面通过远程客户端连接到备库,执行函数pg_promote提升备库为主库.

[pg12@localhostpg12db1]$psql-h192.168.26.27-Upg12-dtestdbpsql(12beta1)Type"help"forhelp.testdb=#--Waitforatmost30seconds.testdb=#SELECTpg_promote(true,30);pg_promote------------t(1row)

日志输出

",,,,,"SELECTpg_promote(true,30);",,,"psql"2019-06-2017:14:22.584CST,,,23160,,5d0b4c04.5a78,5,,2019-06-2017:04:04CST,1/0,0,LOG,00000,"receivedpromoterequest",,,,,,,,,""2019-06-2017:14:22.584CST,,,23167,,5d0b4c04.5a7f,2,,2019-06-2017:04:04CST,,0,FATAL,57P01,"terminatingwalreceiverprocessduetoadministratorcommand",,,,,,,,,""2019-06-2017:14:22.625CST,,,23160,,5d0b4c04.5a78,6,,2019-06-2017:04:04CST,1/0,0,LOG,00000,"invalidrecordlengthat0/5016D48:wanted24,got0",,,,,,,,,""2019-06-2017:14:22.625CST,,,23160,,5d0b4c04.5a78,7,,2019-06-2017:04:04CST,1/0,0,LOG,00000,"redodoneat0/5016D10",,,,,,,,,""2019-06-2017:14:22.625CST,,,23160,,5d0b4c04.5a78,8,,2019-06-2017:04:04CST,1/0,0,LOG,00000,"lastcompletedtransactionwasatlogtime2019-06-2017:04:49.180746+08",,,,,,,,,""2019-06-2017:14:22.649CST,,,23160,,5d0b4c04.5a78,9,,2019-06-2017:04:04CST,1/0,0,LOG,00000,"selectednewtimelineID:2",,,,,,,,,""2019-06-2017:14:22.738CST,,,23160,,5d0b4c04.5a78,10,,2019-06-2017:04:04CST,1/0,0,LOG,00000,"archiverecoverycomplete",,,,,,,,,""2019-06-2017:14:22.755CST,,,23158,,5d0b4c04.5a76,3,,2019-06-2017:04:04CST,,0,LOG,00000,"databasesystemisreadytoacceptconnections",,,,,,,,,""2019-06-2017:14:22.764CST,,,23277,,5d0b4e6e.5aed,1,,2019-06-2017:14:22CST,,0,FATAL,XX000,"archivecommandfailedwithexitcode127","Thefailedarchivecommandwas:/home/pg12/archive.sh",,,,,,,,""2019-06-2017:14:22.766CST,,,23158,,5d0b4c04.5a76,4,,2019-06-2017:04:04CST,,0,LOG,00000,"archiverprocess(PID23277)exitedwithexitcode1",,,,,,,,,""2019-06-2017:15:22.779CST,,,23329,,5d0b4eaa.5b21,1,,2019-06-2017:15:22CST,,0,FATAL,XX000,"archivecommandfailedwithexitcode127","Thefailedarchivecommandwas:/home/pg12/archive.sh",,,,,,,,""2019-06-2017:15:22.781CST,,,23158,,5d0b4c04.5a76,5,,2019-06-2017:04:04CST,,0,LOG,00000,"archiverprocess(PID23329)exitedwithexitcode1",,,,,,,,,""[pg12@localhostpg_log]$

pg_control中的状态

[pg12@localhostpg12db1]$pg_controldata|grepstateDatabaseclusterstate:inproduction

从日志&状态可看出,备库已提升为主库(出错提示是没有找到归档命令).

感谢各位的阅读，以上就是“PostgreSQL的pg_promote有什么作用”的内容了，经过本文的学习后，相信大家对PostgreSQL的pg_promote有什么作用这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是亿速云，小编将为大家推送更多相关知识点的文章，欢迎关注！