Is it required to close a Psycopg2 connection at the end of a script?
Normally when your python program exits, all the sockets it owns will be closed, and open transactions aborts. But it's good practice to close the connection at the very end.
Closing a connection as soon as you don't need it anymore results in freeing system resources. Which is always good.
Keep in mind that if you do close your connection, to first commit your changes. As you can read in the psycopg2 API:
Close the connection now (rather than whenever del is executed). The connection will be unusable from this point forward; an InterfaceError will be raised if any operation is attempted with the connection. The same applies to all cursor objects trying to use the connection. Note that closing a connection without committing the changes first will cause any pending change to be discarded as if a ROLLBACK was performed