Ability to restore a backup to a postgres container?

[brendonparker]

Looking to see if anyone has guidance, or has done this...

I want to add a custom command that can restore a backup to the postgres container.

I have a pretty vanilla container:

var db = builder
    .AddPostgres("db-server")
    .WithDataVolume()
    .WithLifetime(ContainerLifetime.Persistent);
    
db.AddDatabase("db", "demo");

Now I want to add a custom command that can restore a backup (from a pg_dump to that instance). Ideally, on demand (could be use for testing scenarios).

Something like:

db.WithCommand(
    name: "restore-db",
    displayName: "Restore Database",
    executeCommand: context =>
        context
            .ServiceProvider.GetRequiredService<RestoreDatabaseCommand>()
            .ExecuteAsync(context, db)
);

But from here, not sure what my implementation of RestoreDatabaseCommand should look like.

I think I want to run a command against that running container.
Something similar to:

docker cp /path/to/backup.dump <container_name_or_id>:/tmp/backup.dump
docker exec -it <container_name_or_id> pg_restore -U <db_user> -d <db_name> /tmp/backup.dump

Mostly tripped up on how to get the container name.

Anyone else done this? Or have alternative suggestion for how to approach?

[brendonparker]

Ha. I was able to get it to work, but feels super hacky.

1. There isn't a great way to get the generated name of the container. The DcpInstancesAnnotation is internal, so can't poke at it to query to figure that out. So needed to explicitly state the container name like:

var db = builder
    .AddPostgres("db-server")
    .WithDataVolume()
    .WithContainerName("db-server")
    .WithLifetime(ContainerLifetime.Persistent);

2. Then it really was just a matter of running a couple of commands hackily using Process.Start and specifying that container name.

[davidfowl]

I think you're looking for this #10951, which doesn't really exist yet.