Forums

postgresql db connection persistence

How long does an idle database connection persist before it is terminated by the postgresql server?

I don't think it does get terminated. You're responsible for managing your connections so you don't leave idle ones lying around.

OK, thanks. Django has parameters for managing the max lifetime of db connections, just making sure my settings don't conflict with the db server settings. Otherwise, django may try to access a connection terminated by the server and throw an error.

I think (but I'm not sure) that Django will normally handle that for you. Our MySQL servers have a 300 second timeout, and I've never had to tell Django about that -- it just works. Postgres support might be different, though, I suppose.