Postgres康复
Postgres康复
提问于 2017-11-07 16:40:47
在OracleEnterpriseLinux6.2服务器中，一个名为Jasperserver的软件使用postgres数据库9.0.4。在我休假期间，这个软件停止工作，我的同事重新启动服务器。现在我们无法连接到数据库
[root@OHS jasperreports-server-6.0]# ps aux | grep postgres
postgres 12791 0.2 0.0 159424 4520 ? Ss 16:22 0:00 /app/jasperreports-server-6.0/postgresql/bin/postgres -D /app/jasperreports-server-6.0/postgresql/data -p 5433
postgres 12792 0.0 0.0 159560 2744 ? Ss 16:22 0:00 postgres: startup process recovering 0000000100000000000000CE
root 12856 0.0 0.0 103240 876 pts/0 S+ 16:23 0:00 grep postgres在postmaster.log文件中：
[2017-11-07 16:22:24 WET] LOG: database system was interrupted while in recovery at 2017-11-03 15:55:51 WET
[2017-11-07 16:22:24 WET] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
[2017-11-07 16:22:24 WET] LOG: database system was not properly shut down; automatic recovery in progress
[2017-11-07 16:22:24 WET] LOG: consistent recovery state reached at 0/CE529088
[2017-11-07 16:22:24 WET] LOG: redo starts at 0/CE529088
[2017-11-07 16:22:24 WET] LOG: record with zero length at 0/CE5A4DB8
[2017-11-07 16:22:24 WET] LOG: redo done at 0/CE5A4D78
[2017-11-07 16:22:24 WET] LOG: last completed transaction was at log time 2017-10-20 01:48:13.275987+01
[2017-11-07 16:23:19 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:24 WET] FATAL: the database system is starting up
[2017-11-07 16:23:27 WET] FATAL: the database system is starting up
[2017-11-07 16:23:27 WET] FATAL: the database system is starting up
[2017-11-07 16:23:27 WET] FATAL: the database system is starting up
[2017-11-07 16:23:27 WET] FATAL: the database system is starting up
[2017-11-07 16:23:27 WET] FATAL: the database system is starting up
[2017-11-07 16:23:27 WET] FATAL: the database system is starting up我没有任何数据库备份。我怎样才能解决这个问题呢？
回答 1
Database Administration用户
发布于 2017-11-07 17:25:30
我没有任何数据库备份。我怎样才能解决这个问题呢？
- 立刻关闭媒体。
- 对承载表空间的分区进行块级再现。
- 在9.x发行版的最新版本下安装该复制，即9.0.23
- 如果开始的话，感谢众神。
其他选择，
- 哭泣，加入irc.freenode.net #PostgreSQL，找到知道如何手动恢复表空间的人。预计要花两万五千美元。
通常，您可以使用一些技巧来查找0/CE5A4D78并清除后续事务，您会没事的。数据就在那里，只是不一致和不恰当。不过，在这一点上，如果没有测试用例，我认为它超出了DBA.SE的范围，您需要一位顾问。
页面原文内容由Database Administration提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://dba.stackexchange.com/questions/190326
复制相关文章
相似问题
腾讯云开发者
