Re: BUG #10911: pg_upgrade appears to lose the transaction id epoch

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: BUG #10911: pg_upgrade appears to lose the transaction id epoch
Дата
Msg-id
CAM-w4HMdS16opwKtRR1AdMPiK61w0Qw3v+VNrdyBcMFxaH75Ag@mail.gmail.com
Ответ на
BUG #10911: pg_upgrade appears to lose the transaction id epoch (gregburek@heroku.com)
Список
Дерево обсуждения
BUG #10911: pg_upgrade appears to lose the transaction id epoch gregburek@heroku.com
Re: BUG #10911: pg_upgrade appears to lose the transaction id epoch Bruce Momjian <bruce@momjian.us>
Re: BUG #10911: pg_upgrade appears to lose the transaction id epoch Greg Stark <stark@mit.edu>
Re: BUG #10911: pg_upgrade appears to lose the transaction id epoch Greg Stark <stark@mit.edu> 
On Tue, Jul 8, 2014 at 10:17 PM,   wrote:
> Looking at pg_control before the upgrade:
> $ pg_controldata /database/ | grep -i nextxid
> Latest checkpoint's NextXID:          15/1905728256
>
> After the upgrade:
> $ pg_controldata /database/ | grep -i nextxid
> Latest checkpoint's NextXID:          0/1905029398

You could just do "pg_resetxlog -e 15" to work around the problem
(after a clean shutdown).

-- 
greg
В списке pgsql-bugs по дате отправления
Предыдущее
От: Bruce Momjian
Дата:
Следующее
От: Mitu Verma
Дата:
FAQ