Comments (1)
Note: probably there won't be an active "if a connection is returned broken, empty the pool and validate all connections" facility. This sounds difficult to coordinate if more than one connection is currently out and they all break for a server disconnection.
Rather than that there should be a function to temporarily empty the pool, verify the connections state, and either put them back if sane else create a new one. The function should be called by the application, which might proactively detect disconnection using the technique documented, so that only one thread would be responsible for it and only if needed.
from psycopg.
Related Issues (20)
- Bad decoding of connection cancel error message HOT 2
- Allow sending updated timeout to notifies generator HOT 2
- Segmentation Fault on mac HOT 1
- Suggestion: Replace SELECT 1 with an empty query HOT 2
- Detecting disconnection documentation
- excecute with str argument? HOT 4
- Copy data as fast as possible with a job in the cloud (Big query and Cloud SQL)
- Suggestion: scalar_row to type check at runtime HOT 1
- RuntimeWarning: coroutine 'AsyncCursor.execute' was never awaited HOT 7
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c' HOT 6
- What am I missing regarding ConnectionPool max_lifetime and FastAPI HOT 6
- v = connection.exec_driver_sql("select pg_catalog.version()").scalar() returning bytestring instead of str on Azure Postgres with psycopg>3 and sqlalchemy2 HOT 5
- psycopg-binary SHA256 mismatch HOT 6
- enhancement: Support for pgbouncer SHOW STATS (disabling Extended Query Protocol) HOT 2
- Document how to connect to pgbouncer HOT 1
- Add instructions to build documentation from source HOT 3
- malloc: double free for ptr 0x1243fd200 HOT 4
- Django 4 - ProgrammingError the last operation didn't produce a result HOT 2
- terminated by signal SIGSEGV (Address boundary error) HOT 10
- Is possible to stdout the command run by `copy.write_row`? HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from psycopg.