Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > When we do a PITR recovery based on xid, does it stop recovery based on > > the start of the xid or the commit of the xid? > > You can stop either "before" or "after" that commit. See > recovery.conf.sample (I don't think it's documented anywhere else > yet :-(),
Yea, my question is if you choose "after", do you get everything that happens until the "after" transaction commits, or just when it begins. If I stop after xid 125, and xid 126 starts and stops before 125 commits, does 126 get restored? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match