Re: Replication failed after stalling - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Replication failed after stalling
Date
Msg-id CAL_0b1t8mho7O9CCYn7SxByHoQMJkvM4vRXS6w5hL899uTubYw@mail.gmail.com
Whole thread Raw
In response to Replication failed after stalling  (Joe Van Dyk <joe@tanga.com>)
Responses Re: Replication failed after stalling  (Joe Van Dyk <joe@tanga.com>)
List pgsql-general
On Wed, Dec 18, 2013 at 11:26 AM, Joe Van Dyk <joe@tanga.com> wrote:
> I'm running Postgresql 9.3. I have a streaming replication server. Someone
> was running a long COPY query (8 hours) on the standby which halted
> replication. The replication stopped at 3:30 am. I canceled the long-running
> query at 9:30 am and replication data started catching up.

What do you mean by "COPY on the standby halted replication"?

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com


pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: Question(s) about crosstab
Next
From: Joe Conway
Date:
Subject: Re: Question(s) about crosstab