I am getting the error "FATAL: sorry, too many clients already" in in my local Galaxy instance in the POSTGRES database log.
I have set max_connections = 1000 in already in "postgresql.conf" and STILL get this error...
I was running a Flowcell with about 96 samples and a workflow with about 50 steps each, but I never had a problem before when max_connections was set to 100 and did not change the database...
I do have a cluster that is much faster so i guess there may be several connections going to the database, but maybe there is some leakage in the galaxy code that is not closing the connections?
It really screws up the galaxy instance and jobs are just in limbo and never finsihed (in the database)...
database_engine_option_pool_size = 20
database_engine_option_max_overflow = 40
already but maybe I set those too high?
What is a normal setting for max_connections in galaxy production servers?
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/