Обсуждение: Re: pg_ugprade and missing timeline
Hi,
On Thursday, March 19, 2015, Kelley Reynolds <kelley.reynolds@rubyscale.com> wrote:
This is rather a hack than a proper solution though...
--
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.
Regards,
Alexey
--
Regards,
Alexey Klyukin