GeezerVison

Bracketed IPv6 DSN hosts now validate the complete host/port specification. For example, postgresql://user@[::1]:5432trailing/database previously matched only [::1]:5432, so the driver silently connected using the valid prefix. A nonnumeric port or a second port suffix could similarly fall back to the default or first port.

The host parser now uses re.fullmatch(). An empty port remains valid and selects the default: postgresql://user@[::1]:/database continues to work. This leaves valid-DSN query-port precedence unchanged; that is the separate scope of #1377.

The three malformed-host regressions fail on master, while the empty-port control passes there. The public asyncpg.connect() API also rejects each malformed URI with ClientConfigurationError.

Validation on macOS arm64 / Python 3.13.18 and native PostgreSQL 18.6:

• make test PYTHON=.venv/bin/python: all three complete suites passed — asyncio debug, default asyncio, and uvloop. Each ran 380 cases with six skipped and no failures (120.677s / 112.217s / 110.770s).
• Full Flake8 and mypy checks passed (27 source files); the complete test suites also run the repository's code-quality tests.

The first local full run exposed a missing pg_resetwal test utility in the isolated PostgreSQL installation. After providing it, the large-OID test passed and all three complete suites above passed. The skipped tests retain the suite's platform/dependency conditions.