Re: Non-superuser connection limit exceeded

From: Richard Huxton <dev(at)archonet(dot)com>
To: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Non-superuser connection limit exceeded
Date: 2004-08-05 14:38:02
Message-ID: 4112464A.6000108@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

marcelo Cortez wrote:
> Hi folks
>
>
> My application fail with 'Non-superuser connection
> limit exceeded' error , the client application is
> connected via ODBC AND GPF MESSAGE appear there.
>
> the 'Non-superuser connection limit exceeded'
> what'wrong?.

You have too many connections active, so you cannot connect. This
shouldn't trigger a GPF anywhere though.

Look at the top of the postgresql.conf file and increase the connection
limit. You'll also want to do some basic tuning of performance settings,
see the article at
http://www.varlena.com/GeneralBits/

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jerry LeVan 2004-08-05 14:49:10 PQunescapeBytea Question
Previous Message Tom Lane 2004-08-05 14:37:41 Re: PG over NFS tips