Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 619BA632A5E for ; Tue, 10 Aug 2010 21:51:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 60089-05 for ; Wed, 11 Aug 2010 00:51:17 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by mail.postgresql.org (Postfix) with ESMTP id 6393F632867 for ; Tue, 10 Aug 2010 21:51:17 -0300 (ADT) Received: from [192.168.1.7] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis) id 0LodTi-1PPCBP0W0Q-00gX2I; Wed, 11 Aug 2010 02:51:13 +0200 Message-ID: <4C61F3FF.1080303@2ndquadrant.com> Date: Tue, 10 Aug 2010 20:51:11 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Tom Lane CC: xsun , pgsql-admin@postgresql.org Subject: Re: The function of lock file named ".s.PGSQL..lock" on Linux? References: <16464.1281026474@sss.pgh.pa.us> In-Reply-To: <16464.1281026474@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:7LSMG2KcxdRuYi/GPgePVZwcIL4UNUt7diZHzp5GLB5 zZdPln0gm7pfPQWqUZ8EaJX14x4FXIu4ykmPJS+nYmDWJYDmDG /5RWU/ngwNqQe4/2F9pS1KmrERi3ffc6UJEbNYUF4Oxm18F0ea MWoPyLu1d0z0Hbilf+i4mUWUJYSuHCNsOuJNzgewGOuyh9lBfJ g7QwHERbyCVzPOvgT5ApeHCukqiJtUSio/+DjIdKrE= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/81 X-Sequence-Number: 35330 Tom Lane wrote: > We can't portably lock the socket file itself, so we make a separate > ordinary file for locking purposes. > It looks to me like the fact that the .lock file is created is only documented in src/backend/utils/init/miscinit.c , and even there the reason why (what you wrote above) isn't mentioned. Seems like noting this file is created in the unix_socket_directory entry of the docs, and the rationale for why in the source code, would make a useful improvement. Anybody want to write a little documentation patch? -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us