pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Samed YILDIRIM <samed@reddoc.net>
To: Dhandapani Shanmugam <postgresql95@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: replication issue
Date: Mon, 09 Apr 2018 11:59:16 +0300
Message-ID: <17232561523264356@web11j.yandex.ru> (raw)
In-Reply-To: <CAAj4MFHbgUaqnHzJ2ZoruhOPRpowdk8grY2k3_0yk+0-XawPVw@mail.gmail.com>
References: <CAAj4MFFt4_W2JewTRf4xC-WyenFMHJziD39mb-rvbxE7=WGPNw@mail.gmail.com>
	<CAAj4MFHbgUaqnHzJ2ZoruhOPRpowdk8grY2k3_0yk+0-XawPVw@mail.gmail.com>

<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.postgres... href="https://www.postgresql.org/docs/10/static/continuous-archiving.html#BACKUP-TIMELINES">https:/... 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" &lt;postgresql95@gmail.com&gt;:</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">&lt;<a href="mailto:postgresql95@gmail.com" target="_blank">postgresql95@gmail.com</a>&gt;</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>

view thread (6+ messages)  latest in thread

Message-ID: <17232561523264356@web11j.yandex.ru>
Permalink:  ../17232561523264356@web11j.yandex.ru/
Also on:    postgresql.org/message-id/17232561523264356@web11j.yandex.ru

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: samed@reddoc.net, postgresql95@gmail.com
  Subject: Re: replication issue
  In-Reply-To: <17232561523264356@web11j.yandex.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox