Re: Streaming replication failed to start scenarios

Hey Laurenz Albe,

Thank you for the quick reply..

> 3. When the dead primary is switchedto standby the streaming is not
> happening due to current_wal_location is ahead in the standby server
is
> ahead of wal_sent_location. In this case how can I start streaming
without
> taking a fresh base backup from current primary ??

>>The parenthesis in your previous question and this question suggest
>>that you missed out on one thing:

>>When the standby is promoted, it starts a new time line, so it
>>is on a different time line from the old master. The old
>>primary cannot be turned to a standby without a new base backup
>>(possibly via rsync to speed up things).

>>This time line switch is a mechanism that prevents precisely
>>the problems you are anticipating.

But taking 200 GB to 500 GB DB base backup is impossible for me. Is there
any other solution ??

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-failed-to-start-scenarios-tp5728519p5728557.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.