Add remote db to pgadmin resource

[akovanev]

Hello,

I am using the following code to add a PostgreSQL resource:

var postgres = builder.AddPostgres(postgresName, user, password, port)
    .WithDataVolume($"{postgresName}-volume")
    .WithPgAdmin(pgAdmin =>
    {
        pgAdmin.WithHostPort(5050);
        pgAdmin.WithLifetime(ContainerLifetime.Persistent);
    });

It works well when dealing with the databases that are running locally. But when I tried to add a remote db mapped to a local port I realized that it is a bit tricky for instance to setup the hostname (I failed with the host.docker.internal) and the maintenance db (it is not postgres in my case) from the code. I can still register the server manually though.

Did I miss anything? My current aspire version is 13.1.2.

[David Fowler (davidfowl)]

but when I tried to add a remote db mapped to a local port I realized that it is a bit tricky for instance to setup the hostname (I failed with the host.docker.internal) and the maintenance db (it is not postgres in my case) from the code. I can still register the server manually though.

What does this mean exactly?

My current aspire version is 13.1.2.

Aspire's current version is 13.3.5.

[akovanev]

I didn't find how to setup these two properties in the code

[David Fowler (davidfowl)]

Today WithPgAdmin reads the configuration from postgres and emits the right magic that pgadmin needs to talk to postgres. It seems like you are asking for a standalone pgadmin resource that can be used to point to your remote postgres. We don't currently have that resource shape.

[akovanev]

Fair enough. The idea is basically to be able to debug against the staging DB, if needed, with the same user experience that the dashboard provides.
Thank you for the answer.

[David Fowler (davidfowl)]

You can manually add the pgadmin container and configure it in the ui.