Skip to main content

PostgreSQL

PostgreSQL is the recommended provider for most workloads. It supports both the Master database and Agent transport layers.

Install​

dotnet add package JobMaster.Postgres

Configuration​

builder.Services.AddJobMasterCluster(config =>
{
    config.ClusterId("My-Cluster")
          .UsePostgresForMaster("Host=...;Database=...;Username=...;Password=...");

    config.AddAgentConnectionConfig("Postgres-1")
          .UsePostgresForAgent("Host=...;Database=...;Username=...;Password=...");
});

Options​

Table prefix​

By default, JobMaster creates tables with the jm_ prefix. Override it per layer:

config.UseSqlTablePrefixForMaster("myapp_jm_");

config.AddAgentConnectionConfig("Postgres-1")
      .UseSqlTablePrefixForAgent("myapp_agent_");

Disable auto schema provisioning​

By default, JobMaster creates and migrates its tables on startup. Disable this if you manage schema migrations yourself:

config.UsePostgresForMaster("...")
      .DisableAutoProvisionSqlSchema();