[ome-users] connection limit problem starting omero

[josh.moore at gmx.de]

Hi Allison.

Postgresql is setup with a maximum number of connections in the
postgresql.conf file:

#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

#listen_addresses = 'localhost'         # what IP address(es) to listen on; 
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost', '*' = all
                                        # (change requires restart)
#port = 5432                            # (change requires restart)
max_connections = 30                    # (change requires restart)

In your case, it looks like they've all been consumed, so you'll need
to set the number higher and restart postgres. The configuration file
could be in a number of places; how did you install postgres and/or
OMERO?

Cheers,
~Josh.

Allison McArton writes:
 > Hi everyone. I'm Allison working on the connectivity of the OMERO  
 > server with ImageJ. I'm trying to set up omero on mac os x 10.5 and I  
 > am getting the following exception:
 > 
 > org.jboss.resource.JBossResourceException: Could not create  
 > connection; - nested throwable: (org.postgresql.util.PSQLException:  
 > FATAL: connection limit exceeded for non-superusers)
 > 
 > 
 > Any suggestions?
 > 
 > 
 > Thanks,
 > Allison