[postgis-users] Postgis concurrence question

[Robert Coup]

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 :)