BUG #12560: can not run alot of databases - Mailing list pgsql-bugs

From cadabreenow@gmail.com
Subject BUG #12560: can not run alot of databases
Date
Msg-id 20150116021019.2590.75917@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12560: can not run alot of databases  (Mike Porter <mike@udel.edu>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12560
Logged by:          haydar
Email address:      cadabreenow@gmail.com
PostgreSQL version: 9.1.0
Operating system:   debian 7.8
Description:

hello,
i use postgresql on my server and i run isida jabber bot on my server with
postgresql
but i have a FATAL error when i run too many bots about 200 bot
my server ram is 48 GB
and see the error message

root@Boy /bots/linux/cham/is # cd /bots/linux/cham/is; ./launch.sh
[02:09:22] --------------------------------------------------

********************************************************
*** Isida is crashed! It's imposible, but You do it! ***
********************************************************

FATAL:  sorry, too many clients already
FATAL:  sorry, too many clients already


Traceback (most recent call last):
  File "isida.py", line 137, in <module>
    try: execfile('kernel.py')
  File "kernel.py", line 1780, in <module>
    if base_type == 'pgsql': conn = psycopg2.connect(database=base_name,
user=ba
se_user, host=base_host, password=base_pass, port=base_port)
  File "/usr/local/lib/python2.7/site-packages/psycopg2/__init__.py", line
179,
in connect
    connection_factory=connection_factory, async=async)
OperationalError: FATAL:  sorry, too many clients already
FATAL:  sorry, too many clients already

==================================================================


please ineed help about that faster

pgsql-bugs by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Partial indexes on VARCHAR get double converted from text
Next
From: Kevin Perais
Date:
Subject: Re: BUG #12556: Clause IN and NOT IN buggy