Minor fixes and improvements.

Improvements

Python 3.12 and PostgreSQL 16 support (#1084) (by @elprans in deea86ce)
Add support for tuple-format custom codecs on composite types (#1061) (by @elprans in 922fcd10)
Support target_session_attrs in URL format, add tests (#1073) (by @elprans in 7cb4e70d)
Infinity numeric support (#1067) (by @krokoziabla in 0c3bf600 for #1020)
Add support for the WHERE clause in copy_to methods (#941) (by @kaylynn234 in b7ffab6c)
Add query logging callbacks and context manager (#1043) (by @dcwatson in b2697ffd)

Fixes

When prepared statements are disabled, avoid relying on them harder (#1065) (by @elprans in cbf64e18)
Handle environments with HOME set to a not-a-directory (#1063) (by @elprans in af922bcf)
Fix handling of non-ASCII passwords (#1062) (by @elprans in 89d5bd03)
Disable JIT while doing type introspection (#1082) (by @elprans in f21ebf64)
Remove connection parameter caching in Pool (#1053) (by @ermakov-oleg in 4ddb0397)
Switch to Python 3.12-style wait_for (#1086) (by @elprans in 4bdd8a7e)
Update automatic PostGIS type conversion for Shapely 2.0 (#1085) (by @ChimneySwift in 8b45beb4)
Use the timeout context manager in the connection path (#1087) (by @elprans in 313b2b2b)
Small fix for documentation on using SSL in Connection (#995) (by @ScottFred in ccc7baf9)
Use cleanup_ctx in pool usage doc (#878) (by @ir4y in 70c8bd81)
Close cursor portals once the iterator is exhausted (#1088) (by @elprans in ca9f03be)
Cut BaseProtocol circular reference on close. (#1049) (by @pteromys in 93a6f79a)
Allow passing hosts as tuples to connect() (in addition to lists) (#1021) (by @lezram in d7faaff5)