Re: pg_ugprade and missing timeline

Поиск
Список
Период
Сортировка
От Alexey Klyukin
Тема Re: pg_ugprade and missing timeline
Дата
Msg-id CAAS3tyJ5b-CiwdJ-Lx=8rSgV_bER4AAJeZQ463GqgvcMDKNmBA@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi,



On Thursday, March 19, 2015, Kelley Reynolds <kelley.reynolds@rubyscale.com> wrote:
I have just been bitten by the same pg_upgrade/timeline bug that you experienced in this thread:

http://www.postgresql.org/message-id/CAAS3tyKOvC-5dRqQLj+T=tuHmrsVetBznFOwRgvLFYuzjtE90w@mail.gmail.com

I read your description about how you manually placed a timeline file on the new master but I can't quite figure out exactly what should go in there, I have no existing timeline files and I have no idea what one looks like. Can you give me some more details on how to create that file to get streaming replication working again?

I think the fastest way to get a timeline file is to initialize a new PostgreSQL cluster and promote it afterwards. Make sure you have archiving turned on and look at the archive destination after promotion. You will get a new  .history file. Just copy this file to your master, renaming it to the timeline number the replica requires.

This is rather a hack than a proper solution though...


Regards,
Alexey

 


--
Regards,
Alexey Klyukin

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: unix socket location confusion
Следующее
От: "Ruth Melendo"
Дата:
Сообщение: Re: How to desconfigure BDR?