Quick Links

Re: postgres streaming replication for HA

From:	Samed YILDIRIM <samed(at)reddoc(dot)net>
To:	Sunil N Shinde <sunil(dot)shinde(at)mastek(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject:	Re: postgres streaming replication for HA
Date:	2017-09-08 10:54:54
Message-ID:	106341504868094@web42j.yandex.ru
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

<div>Hi Shinde,</div><div> </div><div>Could you please share recovery.conf file?</div><div> </div><div>Logs means that xlog file (000000030000000000000013) which is required by your standby has been removed before streamed to standby. To avoid this kind of situations you can use replication slot or you should set wal_keep_segment high enough.</div><div> </div><div>Best regards.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>08.09.2017, 11:40, "Sunil N Shinde" <sunil(dot)shinde(at)mastek(dot)com>:</div><blockquote type="cite"><div link="blue" vlink="purple" lang="EN-IN"><div>Hi Samed, Please find below the log details also : cp: cannot stat ‘/var/lib/pgsql/9.6/data/archive/000000030000000000000013’: No such file or directory< 2017-09-08 08:36:25.852 UTC > LOG: started streaming WAL from primary at 0/13000000 on timeline 3< 2017-09-08 08:36:25.852 UTC > FATAL: could not receive data from WAL stream: ERROR: requested starting point 0/13000000 is ahead of the WAL flush position of this server 0/1102FFF0 <div>Thanks & Regards, Sunil N Shinde Assistant Manager – DBA Mastek Ltd | Mastek Millennium Center, Millennium Business Park, Mahape, Navi Mumbai-400710 . Mob:- 9819002393</div> <div><div style="border:none;border-top:solid #E1E1E1 1pt;padding:3pt 0cm 0cm 0cm;">From: <a href="mailto:pgsql-admin-owner(at)postgresql(dot)org">pgsql-admin-owner(at)postgresql(dot)org</a> [mailto:<a href="mailto:pgsql-admin-owner(at)postgresql(dot)org">pgsql-admin-owner(at)postgresql(dot)org</a>] On Behalf Of Sunil N Shinde Sent: 08 September 2017 12:38 To: Samed YILDIRIM <<a href="mailto:samed(at)reddoc(dot)net">samed(at)reddoc(dot)net</a>>; <a href="mailto:pgsql-admin(at)postgresql(dot)org">pgsql-admin(at)postgresql(dot)org</a> Subject: Re: [ADMIN] postgres streaming replication for HA</div></div> <table style="width:100%;" cellspacing="0" cellpadding="0" align="left" width="100%" border="0"><tbody><tr><td style="background:#910A19;padding:5.25pt 1.5pt 5.25pt 1.5pt;"> </td><td style="width:100%;background:#FDF2F4;padding:5.25pt 3.75pt 5.25pt 11.25pt;" width="100%"><div>This sender failed our fraud detection checks and may not be who they appear to be. Learn about <a href="http://aka.ms/LearnAboutSpoofing">spoofing</a></div></td><td style="width:56.25pt;background:#FDF2F4;padding:5.25pt 3.75pt 5.25pt 3.75pt;" width="60"><a href="http://aka.ms/SafetyTipsFeedback">Feedback</a></td></tr></tbody></table><div>Hi Samed, Thanks for the quick reply. I am trying it manually with below step: 1. Shut down the primary node2. Creating trigger file on standby node before promoting it to primay.3. "recovery_target_timline='latest'” adding this parameter in recovery file on standby and restarting it. On current standby :psql -p 5432 -c "select pg_is_in_recovery();"pg_is_in_recovery-------------------t(1 row) But on Current Primary:psql -c "select application_name, state, sync_priority, sync_state from pg_stat_replication;"application_name | state | sync_priority | sync_state------------------+-------+---------------+------------(0 rows) Thanks & Regards, Sunil N Shinde From: Samed YILDIRIM [<a href="mailto:samed(at)reddoc(dot)net">mailto:samed(at)reddoc(dot)net</a>] Sent: 08 September 2017 12:22 To: <a href="mailto:pgsql-admin(at)postgresql(dot)org">pgsql-admin(at)postgresql(dot)org</a>; Sunil N Shinde <<a href="mailto:Sunil(dot)Shinde(at)mastek(dot)com">Sunil(dot)Shinde(at)mastek(dot)com</a>> Subject: Re: [ADMIN] postgres streaming replication for HA Hi Shinde,<div> </div><div>Do you trying swithover manually? Or do you use any manager or script to handle switchover operation?</div><div> </div><div>Best regards.</div><div> -- Yandex.Mail mobil uygulamasından gönderildi 08:51, 8 Eylül 2017, Sunil N Shinde <<a href="mailto:sunil(dot)shinde(at)mastek(dot)com">sunil(dot)shinde(at)mastek(dot)com</a>>:<blockquote style="margin-top:5pt;margin-bottom:5pt;"> <div> <div> Hi, I am forming 2 node cluster of streaming replication for HA. I could able to succeed with the replication process. But I am not able to complete the “switchover”. Version : postgresql-9.6 OS :RHEL7 Master Node Parameters: wal_level = hot_standby synchronous_commit = local archive_mode = on archive_command = 'cp %p /var/lib/pgsql/9.6/data/archive/%f' max_wal_senders = 2 wal_keep_segments = 10 synchronous_standby_names = 'UWPGRECLUS2' pb_hba.conf # Localhost host replication replica 127.0.0.1/32 md5 # PostgreSQL Master IP address host replication replica 10.0.3.4/32 md5 # PostgreSQL SLave IP address host replication replica 10.0.3.5/32 md5 Slave Node Parameters: wal_level = hot_standby synchronous_commit = local max_wal_senders = 2 wal_keep_segments = 10 synchronous_standby_names = 'UWPGRECLUS2' hot_standby = on Replication is properly happening from master to slave. But I am not able to switchover between the nodes. Can anyone please guide me in this regard? Thanks & Regards, Sunil N Shinde Assistant Manager – DBA Mastek Ltd | Mastek Millennium Center, Millennium Business Park, Mahape, Navi Mumbai-400710 . Mob:- 9819002393 </div> </div> </blockquote></div></div></div></div></blockquote>

Attachment	Content-Type	Size
unknown_filename	text/html	14.5 KB

In response to

Re: postgres streaming replication for HA at 2017-09-08 08:38:23 from Sunil N Shinde

Responses

Re: postgres streaming replication for HA at 2017-09-08 11:11:14 from Sunil N Shinde
Re: postgres streaming replication for HA at 2017-09-08 11:22:50 from Sunil N Shinde

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Sunil N Shinde	2017-09-08 11:11:14	Re: postgres streaming replication for HA
Previous Message	Sunil N Shinde	2017-09-08 08:38:23	Re: postgres streaming replication for HA