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@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
