Re: [GENERAL] clarification about standby promotion

2017-02-10 Thread Michael Paquier
On Fri, Feb 10, 2017 at 7:15 PM, Jehan-Guillaume de Rorthais wrote: > On Thu, 9 Feb 2017 18:27:30 + > Rakesh Kumar wrote: > >> >Sure, but when you are doing a switchover, the standby is supposed to be >> >connected to the master when you shutdown

Re: [GENERAL] clarification about standby promotion

2017-02-10 Thread Rakesh Kumar
>> Kill ? You mean "pg_ctl stop -m fast" right ? Yes. >Use timeline to resync ? Timeline is an internal mechanism in PostgreSQL, not >a tool, so I don't get this step...You mean using pg_rewind ? pg_rewind which uses timeline. -- Sent via pgsql-general mailing list

Re: [GENERAL] clarification about standby promotion

2017-02-10 Thread Jehan-Guillaume de Rorthais
On Thu, 9 Feb 2017 18:27:30 + Rakesh Kumar wrote: > >Sure, but when you are doing a switchover, the standby is supposed to be > >connected to the master when you shutdown the master. So based on the doc, > >the standby should receive **everything** from the master

Re: [GENERAL] clarification about standby promotion

2017-02-09 Thread Venkata B Nagothi
On Fri, Feb 10, 2017 at 2:42 AM, Jehan-Guillaume de Rorthais wrote: > On Thu, 9 Feb 2017 10:41:15 +1100 > Venkata B Nagothi wrote: > > > On Thu, Feb 9, 2017 at 4:53 AM, Benoit Lobréau > > > wrote: > > > > > Hi, > > > > > > > > > I

Re: [GENERAL] clarification about standby promotion

2017-02-09 Thread Rakesh Kumar
>Sure, but when you are doing a switchover, the standby is supposed to be >connected to the master when you shutdown the master. So based on the doc, >the standby should receive **everything** from the master before the master >actually shutdown. We use 9.5 and even in that version there is no

Re: [GENERAL] clarification about standby promotion

2017-02-09 Thread Jehan-Guillaume de Rorthais
On Thu, 9 Feb 2017 10:41:15 +1100 Venkata B Nagothi wrote: > On Thu, Feb 9, 2017 at 4:53 AM, Benoit Lobréau > wrote: > > > Hi, > > > > > > I would like to clarify something about standby promotion. From the > > sentence below. I understand that,

Re: [GENERAL] clarification about standby promotion

2017-02-08 Thread Benoit Lobréau
hi, Tank you for the confirmation ! For the second part, I understand your explanation but I fail to see how checking what we have replayed against what we have received will confirm we have received everything (unless we are in sync replication). Have a good day ! Benoit.

Re: [GENERAL] clarification about standby promotion

2017-02-08 Thread Venkata B Nagothi
On Thu, Feb 9, 2017 at 4:53 AM, Benoit Lobréau wrote: > Hi, > > > I would like to clarify something about standby promotion. From the > sentence below. I understand that, during the promotion process, postgres > will replay all the available wals (from the archive or

[GENERAL] clarification about standby promotion

2017-02-08 Thread Benoit Lobréau
Hi, I would like to clarify something about standby promotion. From the sentence below. I understand that, during the promotion process, postgres will replay all the available wals (from the archive or pg_xlog). https://www.postgresql.org/docs/9.5/static/warm-standby.html#STREAMING-REPLICATION