[postgis-users] Postgis concurrence question

[Luigi Castro Cardeles]

Hi,

the problem seen that your application create for every insert a connection
and not closing that after the insert.
That exacerbates the maximum connection param from postgres (at
postgresql.conf).
Maybe if you modified your application to close that connection after the
insert or uses a pool of connection (like Kiril points).
[]'s

Luigi Castro Cardeles


2009/11/11 Kirill Zinov <kirill.zinov at gmail.com>

> Hello Fernando,
>
> I think this is java application design problem. I don't use PostGIS with
> Java but Postgres works perfectly for me.
>
> Do you use connection pooling?
>
> Kirill,
>
>
> Fernando Tong wrote:
>
>> Thanks for your repplies.
>>
>> Yes, Rob, i'm connecting and disconnecting every time. Here some part of
>> the logs, sorry if it's a noob question but why when the connection is
>> received the port number is increasing? it starts in 3668 and the next
>> connection is 3669 and so on
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091111/7e658b66/attachment.html>