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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
