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 <[email protected] > wrote: > On Thu, Nov 12, 2009 at 6:05 AM, Nandorov <[email protected]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
