酒保+ postgresql在酒保复述后不开始

Question

我用酒保做备份和恢复

在进行了一些恢复之后，我们按以下方式启动postgresql

systemctl start postgresql.service

但是postgresql没有启动

从日志中：

/var/lib/pgsql/backups/data/pg_log

我们看到了以下错误

LOG:  database system was interrupted; last known up at 2017-08-06 07:30:49 UTC
LOG:  restored log file "00000008.history" from archive
LOG:  starting point-in-time recovery to 2017-08-06 07:30:49.813508+00
LOG:  restored log file "0000000800000000000000C1" from archive
LOG:  redo starts at 0/C1000080
LOG:  recovery stopping before commit of transaction 96139, time 2017-08-06 07:30:49.855629+00
LOG:  redo done at 0/C1001B90
FATAL:  requested recovery stop point is before consistent recovery point
LOG:  startup process (PID 55858) exited with exit code 1
LOG:  terminating any other active server processes

请建议什么是错误的配置酒保，导致这一点？

Answer 1

在我看来，你似乎在尝试恢复到一个比备份中记录的时间更早的时间点。

确保您没有指定比您试图还原的备份早的恢复时间。

检查postgres数据目录中的文件recovery.conf和backup.label。如果您想恢复到最新的可能，那么您应该确保在recovery_target_time中没有一个名为recovery.conf的属性。