On Thu, 2011-10-20 at 12:45 -0400, Adam Tistler wrote:
> Yes you understood correctly. Would the same apply for a hot standby situation?
Right. Hot standby just means that you can query (read-only) an instance
that's still in recovery.
Basically, going from recovery mode (or hot standby, which is also
recovery mode) to "up" (that is, can accept write queries and operate
normally) is not a reversible process. You have to make a new base
backup of another system to start recovering again.
Regards,
Jeff Davis