postgresql - How to get replication events for all databases - Stack Overflow

admin管理员组

文章数量:1401653

Replication events are displayed by ASP.NET Core 9 MVC controller according using code:

public async Task Index()
{
    const string slotName = "all_slot";
    await ctx.Database.ExecuteSqlAsync("create publication Jalgi_pub for all tables;");
    await ctx.Database.ExecuteSqlAsync(@$"SELECT * FROM pg_create_logical_replication_slot({slotName}, 'pgoutput' , false );");

    await using LogicalReplicationConnection conn = new("host=localhost;database=postgres");
    await conn.Open();

    PgOutputReplicationSlot slot = new(slotName);
    CancellationTokenSource cancellationTokenSource = new();

    await foreach (PgOutputReplicationMessage m in conn.StartReplication(
        slot, new PgOutputReplicationOptions("jalgi_pub", PgOutputProtocolVersion.V4), cancellationTokenSource.Token))
    {
        await Response.WriteAsync($"{m.GetType().Name}<br>");
        conn.SetReplicationStatus(m.WalEnd);
    }
}

Code is based is sample from .html

This shows events from Postgres database only. How to show events from all databases in the cluster?

本文标签： postgresqlHow to get replication events for all databasesStack Overflow