Re: Point in Time Recovery - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Point in Time Recovery
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D145@m0114.s-mxs.net
Whole thread Raw
In response to Point in Time Recovery  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Point in Time Recovery  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
> The starting a new timeline thought works for xlogs, but not for clogs.
> No matter how far you go into the future, there is a small (yet
> vanishing) possibility that there is a yet undiscovered committed
> transaction in the future. (Because transactions are ordered in the clog
> because xids are assigned sequentially at txn start, but not ordered in
> the xlog where they are recorded in the order the txns complete).

Won't ExtendCLOG take care of this with ZeroCLOGPage ? Else the same problem
would arise at xid wraparound, no ?

Andreas


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Point in Time Recovery
Next
From: Simon Riggs
Date:
Subject: Re: Point in Time Recovery