Re: multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit
Date: 2009-09-23 18:27:51
Message-ID: db471ace0909231127t6d69de47l17c9231f1a02ea46@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Tom,

> What PG version is this?  8.4 has a connection leak in some cases:
> http://archives.postgresql.org/pgsql-committers/2009-09/msg00125.php
>
> This fix hasn't made any released version yet, but you could apply the
> source patch shown there.

This is 8.4.0 on Windows. Looks like it's the bug you mention. I guess
I'll just upgrade to 8.4.1.

Thanks,
Peter Geoghegan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message JC Praud 2009-09-23 19:28:07 grants on pg_stats_activity
Previous Message Martin Gainty 2009-09-23 18:15:05 Re: Source for CreatedSharedMemoryAndSemaphores