org.postgresql.util.PSQLException: FATAL: too many connections for role "iyraxwqa"

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via Stack Overflow by Viking
, 8 months ago
FATAL: too many connections for role "iyraxwqa"
via Stack Overflow by SSchneid
, 8 months ago
FATAL: remaining connection slots are reserved for non-replication superuser connections Ort: Datei: postinit.c, Routine: InitPostgres, Zeile: 779. Server SQLState: 53300
via Stack Overflow by gnorsilva
, 10 months ago
FATAL: database "dbsetupspec" does not exist Location: File: postinit.c, Routine: InitPostgres, Line: 841 Server SQLState: 3D000
via Stack Overflow by Kais
, 2 months ago
FATAL: database "localhost:5432/deliverp" does not exist
via Stack Overflow by crusy
, 11 months ago
ERROR: deadlock detected Detail: Process 122 waits for AccessExclusiveLock on relation 69572 of database 16388; blocked by process 97. Process 97 waits for AccessShareLock on relation 69575 of database 16388; blocked by process 122. Hint: See server log for query details.
org.postgresql.util.PSQLException: FATAL: too many connections for role "iyraxwqa"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2586)
at org.postgresql.core.v3.QueryExecutorImpl.(QueryExecutorImpl.java:113)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:215)
at org.postgresql.Driver.makeConnection(Driver.java:404)
at org.postgresql.Driver.connect(Driver.java:272)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:718)

Users with the same issue

37 times, 1 week ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.