Postgres Pro
Downloads
Home   >   mailing lists

Re: Streaming Replication Randomly Locking Up - Mailing list pgsql-general

From Jeff Janes
Subject Re: Streaming Replication Randomly Locking Up
Date
Msg-id CAMkU=1zq5KabJOa-J87-b39BtYfV5=h90Z6DGgy3+Xo+VSUKxw@mail.gmail.com
Whole thread Raw
In response to Re: Streaming Replication Randomly Locking Up  (Andrew Berman <rexxe98@gmail.com>)
Responses Re: Streaming Replication Randomly Locking Up  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view 
On Thu, Aug 15, 2013 at 1:28 PM, Andrew Berman <rexxe98@gmail.com> wrote:
> Hi Jeff,
>
> Here is the full process list at the time it stopped working (I have changed
> the actual username, db and IP for security).  Would the idle in transaction
> process be the culprit?

Most likely, yes.  You should be able to dig into pg_locks to verify.


Cheers,

Jeff

pgsql-general by date:

Previous
From: Andrew Berman
Date:
Subject: Re: Streaming Replication Randomly Locking Up
Next
From: Jeff Janes
Date:
Subject: Re: Streaming Replication Randomly Locking Up