You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
After small one, we got a lot of idle coneections. Looks like backup done too fast to close them correctly. But zero idle after huge one, that most weird part.
as far as i know, it possible to specify timeout for pgdump, like pg_dump -d 'host=... port=... dbname=... user=... keepalives_idle=300' -f dumpfile
On database side we can play with idle_session_timeout.
The text was updated successfully, but these errors were encountered:
We do backup for 2 db, huge and small.
After small one, we got a lot of idle coneections. Looks like backup done too fast to close them correctly. But zero idle after huge one, that most weird part.
as far as i know, it possible to specify timeout for pgdump, like
pg_dump -d 'host=... port=... dbname=... user=... keepalives_idle=300' -f dumpfile
On database side we can play with
idle_session_timeout
.The text was updated successfully, but these errors were encountered: