static void StartReplication(NpgsqlLsn lsn, CancellationToken ct)
{
Task.Run(() =>
{
Console.WriteLine("Starting logical replication on slot {0} with plugin {1}.", SlotName, PluginName);
Console.WriteLine("Press ENTER to finish replication.");
using (var connection = new NpgsqlConnection(ReplicationConnectionString))
{
connection.Open();
using (var stream = connection.BeginReplication(string.Format("START_REPLICATION SLOT {0} LOGICAL {1}", SlotName, lsn), lsn))
using (var reader = new StreamReader(stream))
{
const int flushTimeout = 1000;
var flushTime = 0;
var sw = Stopwatch.StartNew();
while (true)
{
var status = stream.FetchNext();
if (status == NpgsqlReplicationStreamFetchStatus.Data)
{
Console.WriteLine(reader.ReadToEnd());
}
if (sw.ElapsedMilliseconds > flushTime + flushTimeout)
{
stream.Flush();
flushTime += flushTimeout;
}
Thread.Sleep(50);
if (ct.IsCancellationRequested)
{
Console.WriteLine("Finishing replication slot {0}...", SlotName);
break;
}
}
}
}
Console.WriteLine("Replication slot {0} stopped.", SlotName);
});
}