Support for require_auth configuration parameter

[phillip-gaisford]

Is your feature request related to a problem? Please describe. Postgres 16 added a new configuration parameter named require_auth:

PostgreSQL: pgsql: libpq: Add support for require_auth to control authorized auth m

There's also an environment variable: PGREQUIREAUTH

Could it be that pgx does not handle this yet?

Describe the solution you'd like Support for use of require_auth in the database connect URI.

Describe alternatives you've considered None known. Additional context Feature documentation: https://www.postgresql.org/docs/16/libpq-connect.html#LIBPQ-CONNECT-REQUIRE-AUTH

[jackc]

Seems reasonable.