Re: Streaming replication stacked.

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Yoji <y-tsukada(at)xseed(dot)co(dot)jp>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Streaming replication stacked.
Date: 2016-01-05 12:15:30
Message-ID: CAB7nPqT5gxt1qAcn3MMos2tFv-=GkR=Z96QZ8itCVDHvkKynVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 5, 2016 at 5:13 PM, Yoji <y-tsukada(at)xseed(dot)co(dot)jp> wrote:
> I'm using version of 9.4.3.

You should update to 9.4.5 as soon as possible.

> And I have seen same behavior on version of 9.3.4.

As Andreas has already outlined, as hot_standby_feedback is enabled
the master has to wait for the slave and the slave cannot replay from
the master as transactions are running on the hot standby.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2016-01-05 12:24:54 Re: Streaming replication stacked.
Previous Message matshyeq 2016-01-05 11:32:20 Re: Regex "embedded options" does only work on the whole pattern?