Re: Increased I/O / Writes

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Increased I/O / Writes
Date: 2016-05-17 23:11:11
Message-ID: d2ca9399-7017-dd03-b506-eb8a9fe058bb@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2016-05-18 06:08:04 Re: Thoughts on "Love Your Database"
Previous Message Lucas Possamai 2016-05-17 22:56:18 Re: Increased I/O / Writes