OrionLock.Postgres
0.3.0
dotnet add package OrionLock.Postgres --version 0.3.0
NuGet\Install-Package OrionLock.Postgres -Version 0.3.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="OrionLock.Postgres" Version="0.3.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="OrionLock.Postgres" Version="0.3.0" />
<PackageReference Include="OrionLock.Postgres" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add OrionLock.Postgres --version 0.3.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: OrionLock.Postgres, 0.3.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package OrionLock.Postgres@0.3.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=OrionLock.Postgres&version=0.3.0
#tool nuget:?package=OrionLock.Postgres&version=0.3.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
OrionLock.Postgres
PostgreSQL pg_try_advisory_lock backend for OrionLock distributed locking.
Lock lifetime is the PostgreSQL session lifetime: a crashed process releases its locks automatically with no clock-based expiry.
services.AddOrionLock()
.UsePostgres("Host=localhost;Database=app;Username=...;Password=...", o =>
{
o.KeyPrefix = "app:";
o.CommandTimeout = TimeSpan.FromSeconds(30);
});
Notes
- 64-bit integer keys. Postgres advisory locks are keyed by
bigint. The provider hashesKeyPrefix + keywith SHA-256 and takes the first 8 bytes as a little-endianint64. Collision risk is negligible for realistic key counts; useKeyPrefixto namespace if you also share the database withpg_advisory_lockfrom other code paths. - Session-scoped, no clock expiry. A crashed process releases its locks the moment the database session terminates. There is no lease timer in Postgres itself; OrionLock's renewal watchdog only probes the connection liveness.
- Connection pooling. The provider holds each dedicated
NpgsqlConnectionopen for the lifetime of the lock and disposes it on release, returning it to the Npgsql pool only afterpg_advisory_unlockhas run.
Requires the OrionLock package. See https://github.com/tunahanaliozturk/OrionLock.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net10.0
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 9.0.0)
- Npgsql (>= 8.0.5)
- OrionLock (>= 0.3.0)
-
net8.0
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 9.0.0)
- Npgsql (>= 8.0.5)
- OrionLock (>= 0.3.0)
-
net9.0
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 9.0.0)
- Npgsql (>= 8.0.5)
- OrionLock (>= 0.3.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.