删除WAL文件后，PostgreSQL热备份无法启动

Question

我有一台PostgreSQL 9.1热备服务器。WAL文件最终占据了整个硬盘，所以我最终删除了所有WAP文件。我想如何让服务器恢复，所以我运行：

/usr/local/pgsql/bin/pg_ctl start  -D /usr/local/pgsql/data

问题是服务器永远不会完全启动。我看到下面是不间断的缺失WAL文件日志输出：

server starting
sh-4.1$ LOG:  database system was shut down in recovery at 2013-02-10 03:17:06 UTC
LOG:  entering standby mode
cp: cannot stat `/usr/local/pgsql/wals/0000000100000035000000A4': No such file or directory
LOG:  redo starts at 35/A4943928
LOG:  consistent recovery state reached at 35/A4AE8EB8
LOG:  database system is ready to accept read only connections
LOG:  invalid record length at 35/A4AE8EB8
cp: cannot stat `/usr/local/pgsql/wals/0000000100000035000000A4': No such file or directory
LOG:  streaming replication successfully connected to primary
FATAL:  could not receive data from WAL stream: FATAL:  requested WAL segment 0000000100000035000000A4 has already been removed

我怎样才能把服务器拿回来？

Answer 1

您需要从转储(或文件系统副本)重新创建热备用服务器。

有关如何执行此操作的详细信息，请参阅本手册：High Availability, Load Balancing, and Replication

Answer 2

在流式处理mode...Above中将从属主机连接到主要主机之前，请检查所需的wal是否位于要从其进行初始恢复以进行初始恢复的位置。由于您为初始recovery...If进行恢复的位置上的wal段不可用，因此可能会发生问题。这种情况下没有问题，然后在recovery.conf中检查您的wal。