[postgis-users] Postgis concurrence question

[Mateusz Loskot]

Nandorov wrote:
> Hello list,
> 
> I need some advices of what i'm trying to do. I have a lot of GPS devices
> that are sending data(every 10 seconds) to an application (Java). The latter
> connects to a Postgis database and inserts the coordinates as POINT datatype
> in a table. For testing, i'm using the super user postgres
> 
> 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
> 
> It could be a problem for using the super user postgres or something related
> to max_connections (Currently set at 100) in postgres.conf?

Read the logs, Luke!


Check PostgreSQL manual about logging options, enable
detailed logging, check if you get anything interesting.

Best regards,
-- 
Mateusz Loskot, http://mateusz.loskot.net