Re: BUG #3401: PITR does not work in the case ofrecovery_target_xid = 'SELECT_only_transaction_ID'

Simon Riggs wrote:
> On Thu, 2007-06-21 at 11:17 +0000, Katsuhiko Okano wrote:
>
>> Description:        PITR does not work in the case of recovery_target_xid =
>> 'SELECT_only_transaction_ID'
>> Details:
(snip)
> How did you come to choose an xid of this nature?

specify log_statement = 'all'  and log_line_prefix = '[%x]' in postgresql.conf
(I know this approach is not useful and hardly used on actual system management.)

output server log like below:
[621]LOG:  statement: CREATE TABLE xxx(col1 integer);
[622]LOG:  statement: SELECT * FROM xxx;
[623]LOG:  statement: SELECT * FROM xxx;
[624]LOG:  statement: SELECT * FROM xxx;
[625]LOG:  statement: INSERT INTO xxx VALUES (1);
[626]LOG:  statement: INSERT INTO xxx VALUES (2);
[627]LOG:  statement: INSERT INTO xxx VALUES (3);
[628]LOG:  statement: SELECT * FROM xxx;
[629]LOG:  statement: SELECT * FROM xxx;
[630]LOG:  statement: SELECT * FROM xxx;


Regards,
--
--------
Katsuhiko Okano
okano katsuhiko _at_ oss ntt co jp