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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
