> On Jan 24, 2024, at 19:17, Sasmit Utkarsh <utkarshsasmit@gmail.com> wrote:
>
> Need your support on understanding advisory locks in Postgresql and what is the best practice to have advisory locks
andunlocks to work properly when we have multiple process forked from single process?
Advisory locks are a shared resource across all of the database in which they were created, and PostgreSQL isn't aware
ofthe process model that the client is using. If a session creates the advisory lock, that same session will need to
bethe one to release it, and it's up to the client program to keep track of which process is using which session.