| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | olly(at)lfix(dot)co(dot)uk, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: PITR - recovery to a particular transaction |
| Date: | 2004-08-07 18:00:50 |
| Message-ID: | 1914.1091901650@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> 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?
Yes. You don't get to be selective about what to keep: it's everything
up to a certain time instant, and nothing after that. Stopping by XID
is just a different way of identifying what that time instant is.
BTW, stopping "before" an XID actually means stopping just before its
commit or abort record, so transactions that ended before it did will
be included in the recovery.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-08-07 18:07:39 | Re: PITR - recovery to a particular transaction |
| Previous Message | Tom Lane | 2004-08-07 17:41:40 | Re: Backend crashes with notification rule |