have you tried using the psycopg2 driver?
On Wednesday, May 20, 2015 at 12:38:51 AM UTC-5, Bilal Hasan wrote:
>
> I'm having a very annoying issue where the connection to a PostgreSQL
> database hangs and I get a "Attempted to connect to this database 5 times
> unsuccessfully" which renders the whole web application un-usable.
>
> I'm using PostgreSQL 9.3. Web2Py Version
> 2.8.2-stable+timestamp.2013.11.28.13.54.07
>
> Below is the only code I use for this database. I'm not sure why it's
> happening.
>
> jobid = sprint.joblist.insert(**mydict)
> sprint.commit()
> result = sprint(sprint.joblist.id==jobid).select()
>
> db.py:
> sprint =
> DAL('postgres://***********:*******@138.85.**.**:5432/nds_smart_sprint',pool_size=30)
>
> Updated pg8000 driver to latest version still no luck.
>
> I have to manually terminate the idle connection using "ps aux | grep
> postgres"
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
