This is an plugin to the Hangfire to enable PostgreSQL as a storage system. Read about hangfire here: https://github.com/HangfireIO/Hangfire#overview and here: http://hangfire.io/
Install Hangfire, see https://github.com/HangfireIO/Hangfire#installation
Download all files from this repository, add the Hangfire.PostgreSql.csproj to your solution. Reference it in your project, and you are ready to go by using:
app.UseHangfireServer(new BackgroundJobServerOptions(),
new PostgreSqlStorage("<connection string or its name>"));
app.UseHangfireDashboard();First, NuGet package needs installation.
- Hangfire.PostgreSql (Uses Npgsql 6)
- Hangfire.PostgreSql.Npgsql5 (Uses Npgsql 5)
Both packages are functionally the same, the only difference is the underlying Npgsql dependency version.
In Startup.cs ConfigureServices(IServiceCollection services) method add the following line:
services.AddHangfire(config =>
config.UsePostgreSqlStorage(Configuration.GetConnectionString("HangfireConnection")));In Configure method, add these two lines:
app.UseHangfireServer();
app.UseHangfireDashboard();And... That's it. You are ready to go. Also there exists sample application here.
If you encounter any issues/bugs or have idea of a feature regarding Hangfire.Postgresql, create us an issue. Thanks!
SSL support can be enabled for Hangfire.PostgreSql library using the following mechanism:
config.UsePostgreSqlStorage(
Configuration.GetConnectionString("HangfireConnection"), // connection string
connection => // connection setup - gets called after instantiating the connection and before any calls to DB are made
{
connection.ProvideClientCertificatesCallback += clientCerts =>
{
clientCerts.Add(X509Certificate.CreateFromCertFile("[CERT_FILENAME]"));
};
},
new PostgreSqlStorageOptions() // no overload without options, so just pass the default or configured options
);Copyright © 2014-2022 Frank Hommers https://github.com/frankhommers/Hangfire.PostgreSql.
Collaborators: Frank Hommers (frankhommers), Vytautas Kasparavičius (vytautask), Žygimantas Arūna (azygis) and Andrew Armstrong (Plasma)
Contributors: Burhan Irmikci (barhun), Zachary Sims(zsims), kgamecarter, Stafford Williams (staff0rd), briangweber, Viktor Svyatokha (ahydrax), Christopher Dresel (Dresel), , Vincent Vrijburg, David Roth (davidroth) and Tinyakov.
Hangfire.PostgreSql is an Open Source project licensed under the terms of the LGPLv3 license. Please see http://www.gnu.org/licenses/lgpl-3.0.html for license text or COPYING.LESSER file distributed with the source code.
This work is based on the work of Sergey Odinokov, author of Hangfire. http://hangfire.io/