Re: Recovery.conf and PITR

Hello,

On Fri, 9 Aug 2013 16:09:49 +0800, "ascot(dot)moss(at)gmail(dot)com"
<ascot(dot)moss(at)gmail(dot)com> wrote:
> postgres=# select txid_current();
> txid_current
> --------------
> 75666
> (1 row)
>
>
> Can you please advise?

WAL contains REDO log information, which means only COMMITTED
transactions will be recovered. Sequentiality of TXID refers to the
start of the transaction. Transactions can therefore be committed in a
different order (meaning that 75666 could for example be committed
before 75634 in your case).

Remember that if you do not specify "recovery_target_inclusive =
false", your txid target will be included in the recovered server.

For further information, I suggest you look at:
http://www.postgresql.org/docs/9.2/static/recovery-target-settings.html

Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it - www.2ndQuadrant.it