主页 / user-30860

deadlock's questions

Martin Hope
deadlock
Asked: 2014-12-17 14:18:41 +0800 CST
  • 0

当服务器仍在访问从数据库时，我正在进行迁移。我有一个主/从设置。重新启动服务器后，我意识到我无法再连接到 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

关于可能导致此问题的原因以及我可以做些什么来解决这个问题的任何想法？我要陷入恐慌之中。

postgresql error-log
Martin Hope
deadlock
Asked: 2014-06-21 11:27:21 +0800 CST
  • 8

我正在按照本教程设置我的 postgresql 数据库。

http://inventtheweb.blogspot.ca/2012/05/install-postgresql-for-django.html

在我完成运行 CREATE DATABASE 命令并运行 \q

我得到以下回应。

could not save history to file "/var/lib/postgresql/.psql_history": No such file or directory

究竟是什么原因造成的，这会给我带来什么问题吗？

更多信息：正在安装的 postgresql 版本是 9.3，我在 Ubuntu Server 14.04 LTS 上安装它

postgresql ubuntu