fix: add expected_value for db_vacuum retention_period in test_settings
SecondsTimeDelta converts the raw int (172800) to timedelta(days=2),
so the test needs an explicit expected_value.
With the help of Claude.
Fix async listener for UNIX domain socket PostgreSQL connections
When using a UNIX domain socket connection URL like:
postgresql+asyncpg:///prefect?host=/tmp/.SOSHUB&port=25432
SQLAlchemy's make_url() places host and port in query parameters
rather than the standard URL authority section. The pg notify
connection builder now falls back to query params when the standard
URL attributes are None, allowing UNIX socket connections to work.
Closes #20742
Co-Authored-By: Nate Nowack <nate@prefect.io>