Re: timeline X of the primary does not match recovery target timeline Y - Mailing list pgsql-general

From Jeff Davis
Subject Re: timeline X of the primary does not match recovery target timeline Y
Date
Msg-id 1319130525.16256.72.camel@jdavis
Whole thread Raw
In response to Re: timeline X of the primary does not match recovery target timeline Y  (Adam Tistler <atistler@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Adam Tistler
Date:
Subject: Re: timeline X of the primary does not match recovery target timeline Y
Next
From: Ian Harding
Date:
Subject: Extraneous Files