On Sun, Aug 21, 2011 at 10:52 PM, tamanna madaan
wrote:
> Can anyone please suggest me on this .
Both the PostgreSQL and Slony versions you are running have known bugs
that cause problems. Update them first and see if your problem goes
away.
--
Sent via pgsql-general mailing list (pgsql-genera
On 08/18/11 2:17 AM, tamanna madaan wrote:
Yes , restarting the slon resolves the issue. But. there are other
processes also in my application which connect to postgres . Those
processes can also cause "idle in transaction" postgres connection .
So, I was wondering if I can make use of tcp_kee
Can anyone please suggest me on this .
Thanks..
Tamanna
On Thu, Aug 18, 2011 at 2:47 PM, tamanna madaan <
tamanna.mad...@globallogic.com> wrote:
> Hi
>
> Yes , restarting the slon resolves the issue. But. there are other
> processes also in my application which connect to postgres . Those
> pro
Hi
Yes , restarting the slon resolves the issue. But. there are other processes
also in my application which connect to postgres . Those processes can also
cause "idle in transaction" postgres connection . So, I was wondering if I
can make use of tcp_keepalives_idle , tcp_keepalives_interval and
Best Regards,
Abbas
On Mon, Aug 15, 2011 at 11:14 PM, tamanna madaan <
tamanna.mad...@globallogic.com> wrote:
> Hi All
>
> I am using postgres-8.4.0 on a cluster setup with slony-2.0.4 being used
> for replication.
> Recently , I saw a "idle in transaction" postgres process as below.
>
> postgre
Hi All
I am using postgres-8.4.0 on a cluster setup with slony-2.0.4 being used for
replication.
Recently , I saw a "idle in transaction" postgres process as below.
postgres 13052 14742 0 May13 ? 00:00:00 postgres: slon abc 172.16.1.1(49017)
idle in transaction
I wonder what could have lead to th