Re: Connection limit exceeded for non-superusers when there are plenty of available slots

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Connection limit exceeded for non-superusers when there are plenty of available slots
Date: 2013-02-28 20:49:18
Message-ID: CAPTjJmqL1_wMc-n2RCAGpeEGCb=xOkDU80YeYoneuMQdvF5YRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 1, 2013 at 7:38 AM, G B <g(dot)b(dot)coder(at)gmail(dot)com> wrote:
> SHOW superuser_reserved_connections;
>
> 480
>
> SHOW max_connections;
> 500
>
> Is there something I'm missing here? Thanks for your help.

This leaves just 20 connections for non-root users. Did you intend to
set superuser_reserved_connections to 20, thus leaving 480 for normal
use?

ChrisA

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anson Abraham 2013-02-28 20:58:17 Re: postgresql log file not getting update
Previous Message G B 2013-02-28 20:38:03 Connection limit exceeded for non-superusers when there are plenty of available slots