| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | chris kim <chrisk(at)propaas(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fwd: standby stop replicating, then picked back up |
| Date: | 2017-11-07 20:17:34 |
| Message-ID: | 1510085854.2293.4.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-in-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2017-11-07 23:16:47 | Re: idle in transaction, why |
| Previous Message | chris kim | 2017-11-07 20:08:40 | Fwd: standby stop replicating, then picked back up |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2017-11-08 00:32:19 | Re: Fwd: standby stop replicating, then picked back up |
| Previous Message | chris kim | 2017-11-07 20:08:40 | Fwd: standby stop replicating, then picked back up |