当服务器仍在访问从数据库时,我正在进行迁移。我有一个主/从设置。重新启动服务器后,我意识到我无法再连接到 SLAVE。我进入 SLAVE 并尝试重新启动 Postgres,这是它返回的内容:
$ sudo /etc/init.d/postgresql start
* Starting PostgreSQL 9.3 database server
* The PostgreSQL server failed to start. Please check the log output:
2014-12-16 22:14:20 UTC LOG: database system was interrupted while in recovery at log time 2014-12-16 20:57:20 UTC
2014-12-16 22:14:20 UTC HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
2014-12-16 22:14:20 UTC LOG: entering standby mode
2014-12-16 22:14:20 UTC LOG: redo starts at 0/38620168
2014-12-16 22:14:20 UTC LOG: consistent recovery state reached at 0/38680BF0
2014-12-16 22:14:20 UTC LOG: database system is ready to accept read only connections
2014-12-16 22:14:20 UTC PANIC: heap2_redo: unknown op code 32
2014-12-16 22:14:20 UTC CONTEXT: xlog redo UNKNOWN
2014-12-16 22:14:21 UTC LOG: startup process (PID 18357) was terminated by signal 6: Aborted
2014-12-16 22:14:21 UTC LOG: terminating any other active server processes
关于可能导致此问题的原因以及我可以做些什么来解决这个问题的任何想法?我要陷入恐慌之中。
http://www.postgresql.org/docs/9.3/static/release-9-3-3.html