psql: FATAL: the database system is starting up

来源：互联网发布：北京云计算公司编辑：程序博客网时间：2024/05/17 15:38
pg9.6.1在搭建同步流复制的standby库时，启动备库时，报错：[postgres@pghs ~]$ psqlpsql: FATAL:  the database system is starting up后经检查，是postgresql.conf中hot_standby没有设置：hot_standby = on成功： [postgres@pghs ~]$ psqlpsql (9.6.1)Type "help" for help.postgres=#后经大神提点，在执行psql报错的时候，并非是启动备库时，只是是在连接备库时，此时备库时正常的，只是连不上：[postgres@pghs datass]$ psqlpsql: FATAL:  the database system is starting up[postgres@pghs datass]$  ps -ef | grep postgresroot      1822  1777  0 01:00 pts/0    00:00:00 su - postgrespostgres  1823  1822  0 01:00 pts/0    00:00:00 -bashpostgres  1873  1823  0 01:01 pts/0    00:00:00 psqlroot      3962  3942  0 14:35 pts/2    00:00:00 su - postgrespostgres  3963  3962  0 14:35 pts/2    00:00:00 -bashpostgres  4084     1  0 14:41 pts/2    00:00:00 /usr/pg/postgresql-9.6.1/bin/postgres -D /PostgreSQL/9.6.1/datasspostgres  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 -efpostgres  4097  3963  0 14:42 pts/2    00:00:00 grep postgres[postgres@pghs datass]$ netstat -a | grep PGSQLunix  2      [ ACC ]     STREAM     LISTENING     19502  /tmp/.s.PGSQL.5432[postgres@pghs datass]$
0 0