Does database connection stay opened except for errors and explicit closure?

Question

Assuming that no statements to close the connection are made before my script ends and no exception is encountered before closing the connection, does the database's connection stay open?

I'm connecting to the database programmatically via Python Psycopg2 and via Java JDBC4 driver.

You need to be more specific. Are you using a query tool or doing this from code? Provide any relevant code samples. — Adam Houldsworth
– Adam Houldsworth, Commented Apr 20, 2011 at 8:09

intgr · Accepted Answer · 2011-04-21 08:54:28Z

1

Not entirely sure what you want exactly, but let's try:

You can see the connections that exist at any time with PGAdmin or this SQL command

SELECT * FROM pg_stat_activity;

It should be fairly simple to spot when - for your specific use case - the connection closes.
If an SQL query is running at the time you close a connection, I think it will run to completion, ie the backend serving it will remain alive, even if the connection is closed from the client side.

edited Apr 21, 2011 at 8:54

intgr

20.7k6 gold badges63 silver badges73 bronze badges

answered Apr 20, 2011 at 9:17

fvu

33.1k6 gold badges64 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Does database connection stay opened except for errors and explicit closure?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related