Re: pg_upgrade and epoch

Поиск
Список
Период
Сортировка
От Sergey Burladyan
Тема Re: pg_upgrade and epoch
Дата
Msg-id CAJ2ymdjmA9ge3yqbnTb7QFrroqqcLn_bCOLAGS4U_fev3-msJg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade and epoch  (Sergey Konoplev <gray.ru@gmail.com>)
Ответы Re: pg_upgrade and epoch  (Sergey Konoplev <gray.ru@gmail.com>)
Re: pg_upgrade and epoch  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Wed, Apr 23, 2014 at 6:38 AM, Sergey Konoplev <gray.ru@gmail.com> wrote:

BTW, I didn't manage to make a test case yet. Recently, when I was
migrating several servers to skytools3 and upgrading from 9.0 to 9.2,
I noticed that epoch was copied, timeline id was >0 after upgrade, but
...

This is strange, if I not mistaken XID copied by  copy_clog_xlog_xid(void):
and there is no epoch (-e XIDEPOCH) in pg_resetxlog call args

I test it like this:
~/inst/pg9.2/bin/initdb d9.2
/usr/lib/postgresql/9.3/bin/initdb d9.3
~/inst/pg9.2/bin/postgres -D d9.2 -p 5433
^C
~/inst/pg9.2/bin/pg_resetxlog -e 8 d9.2/
~/inst/pg9.2/bin/postgres -D d9.2 -p 5433
    psql -At -h localhost -p 5433 -c 'select txid_current()' postgres
    34359739064
^C
/usr/lib/postgresql/9.3/bin/pg_upgrade -d d9.2 -D d9.3 -b ~/inst/pg9.2/bin -B /usr/lib/postgresql/9.3/bin -k
/usr/lib/postgresql/9.3/bin/postgres -D d9.3 -p 5433 -k`pwd`/s
    psql -At -h localhost -p 5433 -c 'select txid_current()' postgres
    756

34359739064 switched to 756 after upgrade

--
Sergey Burladyan

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: pg_upgrade and epoch
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: pg_upgrade and epoch