[Auth] Passthrough auth for users without a password is broken

[levkk]

Description

Passthrough auth for users in users.toml that don't have a password triggers weird behavior:

1. Connection pool is created and starts sending health checks to database
2. Health checks fail since PgDog can't connect to Postgres without a password

Potential fix

1. Pause pool on creation and resume it when a user connects and provides a password

Potential edge cases

1. When Postgres auth is set to trust, we don't need a password for the user, so it's valid to not provide one and the pool should still be created. Maybe we don't resume it until the user connects anyway?

Reproduce

pgdog.toml

[general]
passthrough_auth = "enabled_plain"

[[databases]]
name = "pgdog"
host = "127.0.0.1"

users.toml

[[users]]
name =  "pgdog"
database = "pgdog"
# Note: no password set.
# It can also be:
# password = "" # Empty string
# We don't differentiate between the two which is bad enough.

Start PgDog and notice the pool being banned on startup.

[Gunnarguy]

Got slightly carried away messing with non-essentials ^^ sending the PR now.

[y-rabie]

Hey! Is there an update on this?

[levkk]

Hey! Is there an update on this?

Hey! Haven't had a chance to look at this yet. Happy to review a PR if you'd want to contribute.

Cheers!