BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID'
От | Katsuhiko Okano |
---|---|
Тема | BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID' |
Дата | |
Msg-id | 200706211117.l5LBHxOv078390@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID'
Re: BUG #3401: PITR does not work in the case ofrecovery_target_xid = 'SELECT_only_transaction_ID' |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 3401 Logged by: Katsuhiko Okano Email address: okano.katsuhiko@oss.ntt.co.jp PostgreSQL version: Head(20070607) Operating system: Fedora Core release 5 (Bordeaux) Description: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID' Details: Transaction ID is wasted even if it is a transaction containing only SELECT. Transaction ID can be specified when recovering using a PITR feature. For example, in recovery.conf, -------- recovery_target_xid = '1100842' -------- A PITR feature does not work in the case which specified transaction ID in recovery_target_xid corresponding to the transaction which contains only SELECT It expects to stop in foward of target ID or in backward of target ID. However, it does not stop while recovery done. Recovery is done to the last and it becomes the newest.(target ID is disregarded) This operation is unexpected.I think that it should describe on a document.
В списке pgsql-bugs по дате отправления: