Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vh8Bl-00A5oJ-33 for pgsql-hackers@arkaria.postgresql.org; Sat, 17 Jan 2026 15:26:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vh8Bl-008m72-0N for pgsql-hackers@arkaria.postgresql.org; Sat, 17 Jan 2026 15:26:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from <9erthalion6@gmail.com>) id 1vh8Bk-008m5N-2a for pgsql-hackers@lists.postgresql.org; Sat, 17 Jan 2026 15:26:09 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from <9erthalion6@gmail.com>) id 1vh8Bi-0010lS-2P for pgsql-hackers@postgresql.org; Sat, 17 Jan 2026 15:26:08 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-b8714a52072so449410066b.3 for ; Sat, 17 Jan 2026 07:26:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1768663565; x=1769268365; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Qyt7996+yit9+f0+CzeJoFn1aGK4EIfPWrwzsh1K/wU=; b=XCKLXpRYzVANi34Ba2IeCAVxqOJogk3r3rffydZ4EAGjbfUT3tt+1yLccsxgb+kWRJ VaH4GAhya9fcUbYR9ZeaM7hF51avuzjexYiIKQTdlcP4z73cpbqbgTsfY1yhmggoUIXF lNx7bomZRxiWT5sQesXmE+qkzkoj2sPrQQ3M7sf9YvHmDqYqHJZjEPy9d+1MuCuXnoKJ GWveCRV8lwtNcYF7ZDYV2dK2oWsF26P7aguziTMyNgAsHquwNH4Mg9Xfn1uuBnkuVWIe of9KovRJ/AbZU7XpOe0edSFuNex/R2PCR4zC8INEaUfwYozlXw8gtOnQal1UlElCNNZh xHjw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768663565; x=1769268365; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=Qyt7996+yit9+f0+CzeJoFn1aGK4EIfPWrwzsh1K/wU=; b=udQi5t6cxl9DxCQgDX2E+H6H2ixejN/nBF+5Ki9eEwqP0wEGci0UQhT0IRwtr0Sibp qpc130jo7f8+1A5VF0rjqHVljDveEgySqsgyNHuTccSyv527aTgXXvpDUfkoK/DG887n ou0GfoNTC39WqQGBViividK64Bdz3S10rqy39SKF/2icG82LPFYdpucGBuy9NydLopu4 zyYq02ozz/GiqaEEEt4tCAlFFiblc1Z4vq93IOtElI3r1WT37js9XjDqMrJ4A802bS3f wRo5oae39wDE7bj3/6jtZSp+M2hNNHMmDfgC+AG15jw9+en5pRd57NGpZEcwlN5dqGCj aPmQ== X-Gm-Message-State: AOJu0Yx6DKzu1XQ+mtIyf93ZQImKgQ1YQ6g30uwI5+aqyjr/RNA6jnnz WJ6d7TGLaJsBKHtyLZr9mTgq9z7TVrU4yDQ2jsJIbKmQ6RobLFVlfA1dcN4x2g== X-Gm-Gg: AY/fxX6anyJj3XDtKsTvYdPCcivLk4NKe/+boWHhaY2VigkjkDVnlbFD5fLSlbqcQKV UC5U+ksxUGbkaAXD3ub+Y/XefycsrHzl/DypAdgCgU7XiySvH71YqJ5iVIjTdkma1t9D50fWTaw p7eA7vzlcYocetSdQ2agDqqDF7SI52X8HlIaQSptTDi/f92kJ/DLKcGZJGsq8PLIRetiqiwrh2J k80jrbti5R7rUnMeEmBDM1YAPGhzLDaS71toHoGlmQ5nF6vksnli7xPMOqdIuVNnMdWNi+txRo0 o1WqwQ//JYeWdkPyYy6cLljn6sFTERCvxosb/V31nExETqjb3Em85kHA/0GhjcCKVnx/Xsaj4J9 YtaQl2PP0NISE7lys16wbUg6Y+bEgNIoA2rEgE6XlkAt4AoCXLquIV4wBEb4Bba8kWrJLHgsWjg aop7xdD9VmAb91tNx83aGAQG6krOCmjqpqqYdxW8RZ4/nZJXe4WYSDzMxr6VYYJTKvwTJ8BE5+D D03DpAhZUw3xRVMWUdzWjmH X-Received: by 2002:a17:907:3f25:b0:b87:63a8:880c with SMTP id a640c23a62f3a-b879690b055mr508327166b.19.1768663565329; Sat, 17 Jan 2026 07:26:05 -0800 (PST) Received: from ddolgov-thinkpadt14sgen1.rmtde.csb (dslb-088-078-017-026.088.078.pools.vodafone-ip.de. [88.78.17.26]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b8795a31fafsm533955066b.66.2026.01.17.07.26.04 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 17 Jan 2026 07:26:04 -0800 (PST) Date: Sat, 17 Jan 2026 16:26:02 +0100 From: Dmitry Dolgov <9erthalion6@gmail.com> To: pgsql-hackers@postgresql.org Subject: Re: File locks for data directory lockfile in the context of Linux namespaces Message-ID: <45swup77t7utfy33lu47mvkb4exzm3oeakz25abqxuvmsyzt3c@5umrpfgc3ypg> References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="7u2oub7w3nl66bkx" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --7u2oub7w3nl66bkx Content-Type: text/plain; charset=us-ascii Content-Disposition: inline > On Fri, Dec 19, 2025 at 03:27:40PM +0100, Dmitry Dolgov wrote: > Hi, > > TL;DR This is a proposal to use file locking with a data directory lockfile at > startup, which helps to avoid potential Linux PID namespace visibility issues. Rebased and fixed a silly error with the flag availability. Feedback is still welcome. --7u2oub7w3nl66bkx Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="v2-0001-Use-open-file-description-locks-for-data-director.patch"