PSQL 9.0.1 FATAL: sorry, too many clients already

Classic Servoy
1

I have installed PostgreSQL 9.0.1 on my Mac Server (10.6.4) by the .dmg from EnterpriseDB and restored the databases from PSQL 8.4.4.
But now I get an error message in pgAdmin (1.12.1) " FATAL: sorry, too many clients already" and in Servoy 522 Server log:

com.servoy.j2db.persistence.RepositoryException: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already FATAL: sorry, too many clients already
at com.servoy.j2db.server.Zc.Zo.Zc(Zo.java:1167)
at com.servoy.j2db.server.Zc.Zo.Zb(Zo.java:1376)
at com.servoy.j2db.server.Zc.Zo.getTable(Zo.java:757)
at com.servoy.j2db.server.Zc.Zo.getTable(Zo.java:243)
at com.servoy.j2db.persistence.ServerProxy.getTable(ServerProxy.java:72)
at com.servoy.j2db.server.Zc.Za.Za(Za.java:514)
at com.servoy.j2db.server.Zc.Za.loadRootObject(Za.java:221)
at com.servoy.j2db.persistence.RootObjectCache.getRootObject(RootObjectCache.java:202)
at com.servoy.j2db.persistence.RootObjectCache.getActiveRootObject(RootObjectCache.java:160)
at com.servoy.j2db.persistence.AbstractRepository.getActiveRootObject(AbstractRepository.java:413)
at com.servoy.j2db.server.ApplicationServer.loadAllSolutionsCompletelyInMem(ApplicationServer.java:12)
at com.servoy.j2db.server.ApplicationServer.main(ApplicationServer.java:409)

What is about this? I made two more installations like this on other Mac servers without this error.

2

Hi Thomas,

What are your connection pool settings on Servoy ?
Also can you check in postgresql.conf what the max_connections is set to ?

3

Hi Robert,

good questions, but I don’t found anything wrong.
However, I made a complete reinstall of the PSQL 9.0.1 and now it’s working without errors.

Thank you again,
Thomas