connecting with configured username/password does not work

[nsallis]

What steps will reproduce the bug? (please provide code snippet if relevant)

I've configured settings with username and password that I would like to use for my embedded instance:

let mut postgresql = PostgreSQL::new(Settings { username: "firehose".to_string(), password: "firehose".to_string(), port: 46461, temporary: true, timeout: Some(std::time::Duration::from_secs(150)), ..Settings::default() });
However, if I attempt to connect to this (for example via sqlx or pgAdmin4, the connection fails because the user cannot be authenticated. Perhaps I'm misunderstanding what this configuration does?
What happens?
I cannot connect to the database (db does get started, and I can verify that the database exists via .database_exists(database_name))
...

What did you expect to happen instead?
To be able to connect to the database with the provided username and password, or at least some static password that I don't have to change every time I build.
...

Information about your environment

• postgresql_embedded version: [REQUIRED] (latest git version [0.19.0])
• Database version: [REQUIRED] (whatever the default is - I'm not sure how to find this)
• Operating system: [REQUIRED] - ubuntu 24.04

[brianheineman]

Hello @nsallis, the Settings.username field is for the PostgreSQL bootstrap user ad it currently only supports the default user postgres. From what you are describing, you might want to manually create a new firehose user for your database? Settings should likely have been designed with a builder pattern to prevent the attempting setting of the username.