Re: pg_ugprade and missing timeline

Hi,

On Thursday, March 19, 2015, Kelley Reynolds <kelley(dot)reynolds(at)rubyscale(dot)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