Connection String Breaks Between Executions Due to .WithDataVolume()

[rodrigosol]

I am attaching a volume to PostgreSQL using the following code snippet:

var postgres = builder.AddPostgres("database")
                      .WithPgAdmin()
                      .WithDataVolume();

However, my service is unable to connect to the database, resulting in the following error:

Unhandled exception. Npgsql.PostgresException (0x80004005): 28P01: password authentication failed for user "postgres"

The connection succeeds when I remove the .WithDataVolume(); line. It appears that the password used in the connection string is being generated anew with each execution, instead of using the password that was generated when the database was initially created.

[davidfowl]

Yes, this is a known issue when using volumes #1151

cc @eerhardt

[rodrigosol]

@davidfowl Sorry! I searched here before opening, but I did not find it. Thanks.

[davidfowl]

The workaround is to specify a password as a parameter

[rodrigosol]

@davidfowl, can you point out some examples or documentation that shows how to set the password?

Probably it is obvious, but I am new to the .NET world and am on the learning curve getting used to Microsoft documentation.

I really appreciate your help! Thanks

[davidfowl]

Wrote something here:

dotnet/docs-aspire#672 (comment)

[davidfowl]

We should document this as a known issue.

[acfuns]

Good job, .WithDataVolume() can pass the database account password validation properly now.

[davidfowl]

This was fixed in 8.1