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)
Список pgsql-bugs
Дерево обсуждения 
On Tue, Jul 8, 2014 at 10:17 PM,  <gregburek@heroku.com> 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
Дата:
Сообщение: Re: BUG #10911: pg_upgrade appears to lose the transaction id epoch
Следующее
От: Mitu Verma
Дата:
Сообщение: Re: BUG #10888: application is getting hanged in the poll() function of libpq.so.