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
>> 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
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
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
>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
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,
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.
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
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