--- title: pg_dbms_lock v2.0 has been released | daily.dev description: pg_dbms_lock v2.0 is a maintenance release of a PostgreSQL extension that emulates Oracle's DBMS_LOCK package using PostgreSQL advisory locks. Key changes... canonical: https://daily.dev/posts/pg-dbms-lock-v2-0-has-been-released-lbseyte2s twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: pg_dbms_lock v2.0 has been released | daily.dev og:description: pg_dbms_lock v2.0 is a maintenance release of a PostgreSQL extension that emulates Oracle's DBMS_LOCK package using PostgreSQL advisory locks. Key changes... og:url: https://daily.dev/posts/pg-dbms-lock-v2-0-has-been-released-lbseyte2s og:image: https://api.daily.dev/og/posts/lbSeytE2s.png og:image:alt: pg_dbms_lock v2.0 has been released og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # pg_dbms_lock v2.0 has been released **[PostgreSQL](https://daily.dev/sources/postgres)** · 2 min read · 1 upvotes · 0 comments ## Summary pg_dbms_lock v2.0 is a maintenance release of a PostgreSQL extension that emulates Oracle's DBMS_LOCK package using PostgreSQL advisory locks. Key changes include compatibility with PostgreSQL 19 and updated support for the pg_background v2+ API. Note that this version breaks compatibility with pg_background prior to v2.0. The extension implements ALLOCATE_UNIQUE(), REQUEST(), RELEASE(), and SLEEP() stored procedures, covering most of Oracle's DBMS_LOCK functionality except DBMS_LOCK.CONVERT() and some unsupported lock modes. It is maintained by HexaCluster under the PostgreSQL license. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [pg\_dbms\_job v2.0 released](https://daily.dev/posts/pg-dbms-job-v2-0-released-jznbxcmdb) · PostgreSQL · 8 upvotes · 2 comments - [pg\_background 2.0: Run SQL in the Background, Now Cleaner, Safer, and Ready for PostgreSQL 19](https://daily.dev/posts/pg-background-2-0-run-sql-in-the-background-now-cleaner-safer-and-ready-for-postgresql-19-wnrct9qqs) · Planet PostgreSQL · 8 upvotes · 0 comments - [pg\_dbms\_errlog v2.4 released](https://daily.dev/posts/pg-dbms-errlog-v2-4-released-xbq5khqmc) · PostgreSQL · 3 upvotes · 0 comments --- Tags: [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/pg-dbms-lock-v2-0-has-been-released-lbseyte2s) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"pg_dbms_lock v2.0 has been released","url":"https://daily.dev/posts/pg-dbms-lock-v2-0-has-been-released-lbseyte2s","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/pg-dbms-lock-v2-0-has-been-released-lbseyte2s"},"datePublished":"2026-07-05T16:26:36.244Z","dateModified":"2026-07-05T16:26:51.650Z","description":"pg_dbms_lock v2.0 is a maintenance release of a PostgreSQL extension that emulates Oracle's DBMS_LOCK package using PostgreSQL advisory locks. Key changes...","image":"https://media.daily.dev/image/upload/s--P4t4XyoV--/f_auto/v1722860399/public/Placeholder%2001","thumbnailUrl":"https://media.daily.dev/image/upload/s--P4t4XyoV--/f_auto/v1722860399/public/Placeholder%2001","isAccessibleForFree":true,"articleSection":"PostgreSQL","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"PostgreSQL","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86","url":"https://daily.dev/sources/postgres"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/pg-dbms-lock-v2-0-has-been-released-lbseyte2s","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"postgresql","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"PostgreSQL","item":"https://daily.dev/sources/postgres"},{"@type":"ListItem","position":3,"name":"pg_dbms_lock v2.0 has been released"}]} ```