Thread: Non-superuser connection limit exceeded

Non-superuser connection limit exceeded

From
marcelo Cortez
Date:
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?.

 Tia

   PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by
GCC 2.96

 Mandrake 8.0



Correo Yahoo! - 6 MB, tecnología antispam ¡gratis!
 Suscribite ya http://correo.yahoo.com.ar/

Re: Non-superuser connection limit exceeded

From
Richard Huxton
Date:
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