psql: FATAL: the database system is starting up

编程入门 行业动态 更新时间:2024-10-14 16:27:12

psql: <a href=https://www.elefans.com/category/jswz/34/1770274.html style=FATAL: the database system is starting up"/>

psql: FATAL: the database system is starting up

pg9.6.1
在搭建同步流复制的standby库时,启动备库时,报错:
[postgres@pghs ~]$ psql
psql: FATAL:  the database system is starting up后经检查,是postgresql.conf中hot_standby没有设置:
hot_standby = on成功:[postgres@pghs ~]$ psql
psql (9.6.1)
Type "help" for help.postgres=#后经大神提点,在执行psql报错的时候,并非是启动备库时,只是是在连接备库时,此时备库时正常的,只是连不上:
[postgres@pghs datass]$ psql
psql: FATAL:  the database system is starting up
[postgres@pghs datass]$  ps -ef | grep postgres
root      1822  1777  0 01:00 pts/0    00:00:00 su - postgres
postgres  1823  1822  0 01:00 pts/0    00:00:00 -bash
postgres  1873  1823  0 01:01 pts/0    00:00:00 psql
root      3962  3942  0 14:35 pts/2    00:00:00 su - postgres
postgres  3963  3962  0 14:35 pts/2    00:00:00 -bash
postgres  4084     1  0 14:41 pts/2    00:00:00 /usr/pg/postgresql-9.6.1/bin/postgres -D /PostgreSQL/9.6.1/datass
postgres  4085  4084  0 14:41 ?        00:00:00 postgres: logger process                                         
postgres  4086  4084  0 14:41 ?        00:00:00 postgres: startup process   recovering 000000010000000000000015  
postgres  4087  4084  0 14:41 ?        00:00:00 postgres: checkpointer process                                   
postgres  4088  4084  0 14:41 ?        00:00:00 postgres: writer process                                         
postgres  4096  3963  0 14:42 pts/2    00:00:00 ps -ef
postgres  4097  3963  0 14:42 pts/2    00:00:00 grep postgres
[postgres@pghs datass]$ netstat -a | grep PGSQL
unix  2      [ ACC ]     STREAM     LISTENING     19502  /tmp/.s.PGSQL.5432
[postgres@pghs datass]$ 

更多推荐

psql: FATAL: the database system is starting up

本文发布于:2024-02-06 10:21:52,感谢您对本站的认可!
本文链接:https://www.elefans.com/category/jswz/34/1748103.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
本文标签:FATAL   psql   database   starting   system

发布评论

评论列表 (有 0 条评论)
草根站长

>www.elefans.com

编程频道|电子爱好者 - 技术资讯及电子产品介绍!