Non-superuser connection limit exceeded

Started by marcelo Cortezover 21 years ago2 messagesgeneral
Jump to latest
#1marcelo Cortez
jmdc_marcelo@yahoo.com.ar

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/

#2Richard Huxton
dev@archonet.com
In reply to: marcelo Cortez (#1)
Re: Non-superuser connection limit exceeded

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