FATAL: failed to create a backend connection

From: Vikas Sharma <shavikas(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: FATAL: failed to create a backend connection
Date: 2018-02-02 12:27:18
Message-ID: CAN6gwKw3K7KR-BoabmCncWH2dQkJzPgcpf1VcfaPKSncw52ftg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi There,

We are using Postgresql 9.3 with pgpool-II-93-3.5.10.
One Master replicating to 3 Standbys using streaming replication. Pgpool is
used for load balancing only.

Lately we are seeing below on application servers.

Caused by: org.postgresql.util.PSQLException: FATAL: failed to create a
backend connection
Detail: executing failover on backend

Are we hitting the max_connections in PgSql instance or pgpool has reached
to max_connections and can't spawn more

Please advise.

Regards
Vikas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavan Teja 2018-02-02 12:47:44 Re: FATAL: failed to create a backend connection
Previous Message Matej 2018-02-02 09:50:17 Re: PG Sharding