Re: [GENERAL] Fwd: standby stop replicating, then picked back up - Mailing list pgsql-general

From Laurenz Albe
Subject Re: [GENERAL] Fwd: standby stop replicating, then picked back up
Date
Msg-id 1510085854.2293.4.camel@cybertec.at
Whole thread Raw
In response to [GENERAL] Fwd: standby stop replicating, then picked back up  (chris kim <chrisk@propaas.com>)
List pgsql-general
chris kim wrote:
> I had a standby hang for a while, not replicating, but then it fixed 
> itself but I'm not sure why it happened in the first place. What would I 
> look into to see why this happened, or any insight into why is greatly 
> appreciated.

You give us precious little information.

If there is nothing suspicious in the log, and hot standby is enabled,
and the standby is configured appropriately, it could be that a conflicting
query on the standby block WAL application for a while.

Yours,
Laurenz Albe



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: chris kim
Date:
Subject: [GENERAL] Fwd: standby stop replicating, then picked back up
Next
From: Rob Sargent
Date:
Subject: Re: [GENERAL] idle in transaction, why