Re: [web2py] Re: maybe too many db connections todb on pythonanywhere

2017-10-24 Thread Manuele Pesenti 
Il 24/10/17 13:47, Giles Thomas ha scritto:
> Hi Manuele,
>
> PythonAnywhere dev here: there's no extra cost if you want to increase
> the maximum number of Postgres connections -- just follow the
> instructions on this help
> page: https://help.pythonanywhere.com/pages/PostgresConnections/.  
> Don't forget to contact us once you've increased the connection count
> so that we can bounce your Postgres instance.
>
Hi Giles!
Good to know I'll try it and contact you immediatly.
Best regards

    M.
>
> All the best,
>
> Giles


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: maybe too many db connections todb on pythonanywhere

2017-10-24 Thread Giles Thomas 
Hi Manuele,

PythonAnywhere dev here: there's no extra cost if you want to increase the 
maximum number of Postgres connections -- just follow the instructions on 
this help page: https://help.pythonanywhere.com/pages/PostgresConnections/. 
  Don't forget to contact us once you've increased the connection count so 
that we can bounce your Postgres instance.


All the best,

Giles


On Monday, 23 October 2017 09:33:48 UTC+1, Manuele wrote:
>
> Thanks Alex,
>
> that's what I get from the db engine about my maximum number of 
> connections:
>
> psql (9.4.11, server 9.4beta3)
> Type "help" for help.
> postgres=# SHOW max_connections;
>  max_connections 
> -
>  20
> (1 row)
>
> reading the suggested wiki page I found this: "PostgreSQL on good hardware 
> can support *a few hundred connections*. If you want to have thousands 
> instead..." so it seams something can be done on the side of the db 
> configuration... if permitted from the service (maybe paying something 
> more).
>
> Cheers
>
> Manuele
>
> On 21/10/2017 00:20, Alex Glaros wrote:
>
> there are a lot of fixes if search on your error string, plus 
> max_connections parm info is at Postgres 
> https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server 
>
> what is your max_connections set to now?
>
> Alex Glaros
>
>
> -- 
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> --- 
> You received this message because you are subscribed to the Google Groups 
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to web2py+un...@googlegroups.com .
> For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: maybe too many db connections todb on pythonanywhere

2017-10-23 Thread Manuele Pesenti 

Thanks Alex,

that's what I get from the db engine about my maximum number of connections:

psql (9.4.11, server 9.4beta3)
Type "help" for help.
postgres=# SHOW max_connections;
 max_connections
-
 20
(1 row)

reading the suggested wiki page I found this: "PostgreSQL on good 
hardware can support *a few hundred connections*. If you want to have 
thousands instead..." so it seams something can be done on the side of 
the db configuration... if permitted from the service (maybe paying 
something more).


Cheers

    Manuele


On 21/10/2017 00:20, Alex Glaros wrote:
there are a lot of fixes if search on your error string, plus 
max_connections parm info is at 
Postgres https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server


what is your max_connections set to now?

Alex Glaros


--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google 
Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to web2py+unsubscr...@googlegroups.com 
.

For more options, visit https://groups.google.com/d/optout.


--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups "web2py-users" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: maybe too many db connections todb on pythonanywhere

2017-10-20 Thread Alex Glaros 
there are a lot of fixes if search on your error string, plus 
max_connections parm info is at 
Postgres https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

what is your max_connections set to now?

Alex Glaros


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.