On Mon, 2007-06-18 at 16:06 +0930, Tom Lanyon wrote:
> Trying to do a PITR on postgres 8.1.8; I've restored the last full
> backup of the cluster dir and put the required WAL files into place.
This problem is fixed in 8.1.9. Seems it was inadvertently introduced in
8.1.7 (Jan 2007) and was not reported as a bug until after 8.1.8 was
out, in early April.
The 8.1.9 release notes make no mention of the bug fix, which isn't very
helpful, I'll agree.
> Jun 18 15:44:39 postgres[29730]: [54-1] LOG: could not fsync segment
> 0 of relation 1663/42607/44092: No such file or directory
> Jun 18 15:44:39 postgres[29730]: [55-1] PANIC: storage sync failed
> on magnetic disk: No such file or directory
It's a duplicate bug. Please check next time before you report.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com