[postgis-users] Postgis concurrence question

[Fernando Tong]

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

2009-11-11 13:16:23 COT [unknown] [unknown] 2004LOG:  connection received:
host=127.0.0.1 port=3668
2009-11-11 13:16:23 COT gpsuser db_gpstracker 2004LOG:  connection
authorized: user=gpsuser database=db_gpstracker
2009-11-11 13:16:23 COT gpsuser db_gpstracker 2004LOG:  disconnection:
session time: 0:00:00.031 user=gpsuser database=db_gpstracker host=127.0.0.1
port=3668
2009-11-11 13:16:23 COT   5300LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-11-11 13:16:23 COT [unknown] [unknown] 5300LOG:  connection received:
host=127.0.0.1 port=3669
2009-11-11 13:16:23 COT gpsuser db_gpstracker 5300LOG:  connection
authorized: user=gpsuser database=db_gpstracker
2009-11-11 13:16:23 COT gpsuser db_gpstracker 5300LOG:  disconnection:
session time: 0:00:00.046 user=gpsuser database=db_gpstracker host=127.0.0.1
port=3669

Best regards

Fernando

On Wed, Nov 11, 2009 at 2:08 PM, Robert Coup <robert.coup at onetrackmind.co.nz
> wrote:

> On Thu, Nov 12, 2009 at 6:05 AM, Nandorov <nandorov at gmail.com> wrote:
> >
> > Everything's working fine after 20 or 15 minutes, the application starts
> to
> > throw the following postgis error:
> > "could not connect to server: connection timed out (0x0000274C/10060)
> > Is the server running on host "127.0.0.1" and accepting TCP/IP
> connections
> > on port 5432"
> > Some statatements can be executed and some other can not
>
> Are you connecting and (not) disconnecting every time you log a piece
> of data, or maybe maintaining one DB connection for each device?
> Sounds like either (a) you're hitting the postgres connection limit
> (see the postgresql.conf, but more importantly fix your code), or (b)
> you've managed to crash one of the server's child processes
> (unlikely). Either way, as Mateusz said, have a look in the logs.
>
> Rob :)
> _______________________________________________
> 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/ca160506/attachment.html>