Thread: BUG #12560: can not run alot of databases

BUG #12560: can not run alot of databases

From
cadabreenow@gmail.com
Date:
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

Re: BUG #12560: can not run alot of databases

From
Mike Porter
Date:
On Fri, 16 Jan 2015, cadabreenow@gmail.com wrote:

Trying increasing max_connections in the postgresql.conf file.

> 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
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

-
Mike Porter
PGP Fingerprint: F4 AE E1 9F 67 F7 DA EA  2F D2 37 F3 99 ED D1 C2