<div>Hi Dhandapani,</div><div> </div><div>It looks a recover operation or a switchover/failover operation has been applied. You can add following line to your recovery.conf file to follow new timeline.</div><div> </div><div>recovery_target_timeline = 'latest'</div><div> </div><div><a href="https://www.postgresql.org/docs/10/static/recovery-target-settings.html">https://www.postgresql.org/docs/10/static/recovery-target-settings.html</a></div><div><a href="https://www.postgresql.org/docs/10/static/continuous-archiving.html#BACKUP-TIMELINES">https://www.postgresql.org/docs/10/static/continuous-archiving.html#BACKUP-TIMELINES</a></div><div> </div><div>Best regards.</div><div><br /></div><div><br /></div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div><br /></div><div><br /></div><div><br /></div><div>09.04.2018, 11:52, "Dhandapani Shanmugam" <postgresql95(at)gmail(dot)com>:</div><blockquote type="cite"><div dir="ltr">I am getting below error in logfile<div><br /></div><div><span>2018-04-09 16</span>:51:00 SGT LOG: invalid record length at 0/1F000098: wanted 24, got 0</div><div><span>2018-04-09 16</span>:51:00 SGT FATAL: highest timeline 1 of the primary is behind recovery timeline 2</div><div><br /></div></div><div><br /><div>On Mon, Apr 9, 2018 at 2:11 PM, Dhandapani Shanmugam <span dir="ltr"><<a href="mailto:postgresql95(at)gmail(dot)com" target="_blank">postgresql95(at)gmail(dot)com</a>></span> wrote:<br /><blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr"><div>Hi All,</div><div><br /></div><div>I am setting up streaming replication and getting below error when starting the postgreSQL instance on stanby server. Need your expert advise</div><div><br /></div><div>postgres <span>26110 26108</span> 0 16:35 ? 00:00:00 postgres: startup process recovering <span>00000002000000000000001</span>F</div><div><br /></div><div>Below are my content of recovery.conf</div><div><br /></div><div>standby_mode = 'on'</div><div>primary_conninfo = 'host=188.33.44.33 port=5432 user=replication'</div><div>restore_command = 'cp /u101/oradata/postgres/<wbr />standby/pg_xlog/%f %p'</div><span><font color="#888888"><div><br /></div><div>-D</div></font></span></div>
</blockquote></div><br /></div>
</blockquote>