[Bug] Expert mode - when creating 2 databases with different passwords only 1 password is used

[thedengerzone]

Bug description

Ive created cluster on hetzner in expert mode where i needed to define 2 databases.
For each ive defined same user "admin" but different passwords(Im certain of this).

When i tried to connect i realised that actually both databases use same password.
I cannot remember if first password is used or second when defining new database.

If needed i can give you example of this by creating new cluster.

Expected behavior

If we define different passwords for different databases they should use the one that is defined

Steps to reproduce

...

Installation method

Console (UI)

System info

Tahoe 26.2, 1e02a8a commit not sure what version, nothing configured.

Additional info

No response

[thedengerzone]

Ok by bad this can be closed. For some unknown reason when you change password for different databases that have same user defined it actually sets the same data for both. Not sure how exactly this works.

[vitabaks]

In PostgreSQL, users/roles are cluster-wide, not per-database. So creating the same user (admin) for two databases still creates one role with one password—the last password set wins.
If you need different passwords per database, create two separate users and grant each access only to its database.