Re: Streaming Replication Randomly Locking Up

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Andrew Berman <rexxe98(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Streaming Replication Randomly Locking Up
Date: 2013-08-16 16:45:34
Message-ID: CAMkU=1zq5KabJOa-J87-b39BtYfV5=h90Z6DGgy3+Xo+VSUKxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 15, 2013 at 1:28 PM, Andrew Berman <rexxe98(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-08-16 17:12:19 Re: Streaming Replication Randomly Locking Up
Previous Message Andrew Berman 2013-08-16 16:26:05 Re: Streaming Replication Randomly Locking Up