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

On Fri, 16 Jan 2015, cadabreenow(at)gmail(dot)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(at)gmail(dot)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(at)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(at)postgresql(dot)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