From: | Katsuhiko Okano <okano(dot)katsuhiko(at)oss(dot)ntt(dot)co(dot)jp> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3401: PITR does not work in the case ofrecovery_target_xid = 'SELECT_only_transaction_ID' |
Date: | 2007-06-22 09:06:48 |
Message-ID: | 467B9128.6050303@oss.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-06-22 10:18:45 | Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can |
Previous Message | Simon Riggs | 2007-06-22 07:38:39 | Re: BUG #3401: PITR does not work in the case ofrecovery_target_xid = 'SELECT_only_transaction_ID' |