Re: Increased I/O / Writes - Mailing list pgsql-general

From John R Pierce
Subject Re: Increased I/O / Writes
Date
Msg-id d2ca9399-7017-dd03-b506-eb8a9fe058bb@hogranch.com
Whole thread Raw
In response to Re: Increased I/O / Writes  (Lucas Possamai <drum.lucas@gmail.com>)
List pgsql-general
On 5/17/2016 3:56 PM, Lucas Possamai wrote:

FATAL:  sorry, too many clients already


I believe that error means you've exceeded max_connections.     query pg_stat_activity and see how many connections are in the various 'states', like..


    select state, count(*) from pg_stat_activity group by state;



-- 
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Lucas Possamai
Date:
Subject: Re: Increased I/O / Writes
Next
From: Achilleas Mantzios
Date:
Subject: Re: Thoughts on "Love Your Database"