zhong ming wu wrote:
> Is it possible to have a warm standby with 8.1?
No. You can set that up so that it replays an entire pile of log files
sitting there when you start the server, which it sounds like you
haven't managed yet because you're trying to treat it like a
warm-standby. But 8.1 isn't capable of applying log files one at a
time; it applies whatever you've got, and then it's done with recovery
and transitions to live. You can't just stop the result and then feed
it the next file, as you've already discovered through experimentation.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us