Postgis on Postgres Aspire Component

[davidsi02]

Hello. Is there any way i can use postgis on aspire postgres component? If not, are there any plans no implement that?

Thank you.

[Alirexaa]

You could use .WithImage("postgis/postgis") like eShop:
https://github.com/dotnet/eShop/blob/556b9e2a794422abec23e6526a16158fef9214e1/src/eShop.AppHost/Program.cs#L10-L12

[davidsi02]

Tried that but I'm getting this error Npgsql.PostgresException (0x80004005): 0A000: extension "postgis" is not available.

On the postgis container::

2024-07-05T16:41:16.0544305 2024-07-05 15:41:16.054 UTC [57] ERROR:  extension "postgis" is not available
2024-07-05T16:41:16.0544821 2024-07-05 15:41:16.054 UTC [57] DETAIL:  Could not open extension control file "/usr/share/postgresql/16/extension/postgis.control": No such file or directory.
2024-07-05T16:41:16.0544847 2024-07-05 15:41:16.054 UTC [57] HINT:  The extension must first be installed on the system where PostgreSQL is running.

[Alirexaa]

Have you tried this?

CREATE EXTENSION postgis

if you using ef following configuration should work:

protected override void OnModelCreating(ModelBuilder builder)
{
    builder.HasPostgresExtension("postgis");
}

[Alirexaa]

See this example https://github.com/Alirexaa/AspirePostgisSample.