当 postgres 运行时,我的 HD 空间不足。我不得不杀死 postgres 并释放一些空间。现在我无法使用以下错误消息重新启动 postgres:
LOG: listening on IPv4 address "0.0.0.0", port 5434
LOG: listening on IPv6 address "::", port 5434
LOG: listening on Unix socket "/tmp/.s.PGSQL.5434"
LOG: database system was interrupted; last known up at 2018-04-16 05:20:46 EDT
PANIC: could not read file "pg_logical/replorigin_checkpoint": Success
LOG: startup process (PID 97490) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
LOG: database system is shut down
里面有data/pg_logical
一个同名的文件,replorigin_checkpoint
但它是空的。
我已经按照此处的建议出于备份原因复制了数据目录,但我实际上并不确定下一步该做什么。amcheck
看起来,它只适用于正在运行的 postgres。
./postgres -V
postgres (PostgreSQL) 11devel
Ubuntu 16.04.4 LTS
也许值得注意的是,文件系统本身就安装在该机器上(nfs
)
问题
1. 里面应该有replorigin_checkpoint
什么?
2. 是否有可能从较早的检查点重新启动?
3. 有哪些类型的损坏修复(不仅是损坏检测)