Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aNPxB-0007mP-L8 for pgsql-admin@arkaria.postgresql.org; Sun, 24 Jan 2016 19:04:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aNPxA-0000Cx-IW for pgsql-admin@arkaria.postgresql.org; Sun, 24 Jan 2016 19:04:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aNPx9-0000CX-Q3 for pgsql-admin@postgresql.org; Sun, 24 Jan 2016 19:03:59 +0000 Received: from mout.gmx.net ([212.227.15.19]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1aNPx6-0003gN-Iw for pgsql-admin@postgresql.org; Sun, 24 Jan 2016 19:03:59 +0000 Received: from auth2-smtp.messagingengine.com ([66.111.4.228]) by mail.gmx.com (mrgmx003) with ESMTPSA (Nemesis) id 0LaWlT-1Zgunu3iP9-00mIvE for ; Sun, 24 Jan 2016 20:03:54 +0100 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailauth.nyi.internal (Postfix) with ESMTP id 6F3C12032C for ; Sun, 24 Jan 2016 14:03:52 -0500 (EST) Received: from frontend2 ([10.202.2.161]) by compute6.internal (MEProxy); Sun, 24 Jan 2016 14:03:52 -0500 X-Sasl-enc: qOuA91XhkBJxTiw7NwfeqcdiLMeE7QdokHdTSYPyUluu 1453662232 Received: from [172.20.10.2] (unknown [166.170.28.58]) by mail.messagingengine.com (Postfix) with ESMTPA id 00F1D680179; Sun, 24 Jan 2016 14:03:51 -0500 (EST) Subject: Re: systemd deletes shared memory segment in /dev/shm/Postgresql.NNNNNN To: mgbii bax , "pgsql-admin@postgresql.org" References: From: Peter Eisentraut Message-ID: <56A52018.1030001@gmx.net> Date: Sun, 24 Jan 2016 14:03:52 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:Mr5wx1Q2zkq1CAxCGM2eTjtrFuUz0Mm4UpuwEZPlUq05X4GAAkL XRK7wQ6WhkWY+dkRNSG9DMpsrtRsyKeUGWXafWILHM34uZGDJUVo8AUwxYqfgTg5HVeyn8j gIIdIrkX9K5H8K9DsowoqOpMltEgO4rIVJj8cQKxLgvGeBawU4Cls8CQx+71Jwh6jrgp2mr +9Dmfi4Ht6HNxhZGMf5lA== X-UI-Out-Filterresults: notjunk:1;V01:K0:ogjT9LoHoU8=:kNAmdTUvPdg00OqsBveLv5 zTWBgHoiQYfQNxkdx7TbRoBmWp4z2aCFKkvYjGdCHJJeBhhEPOH8Fj8i60MvpAN6Gm7U5Be0J iIc5PBQPbDpMBKhthOpdNKNhL0gJVCHm9j5dp/0tDo8zXBQwNzV7WmJuap6j3cU50DUhBNXch 68MVX6Vk3/z5bPvAAsfJK4WUH76TSCWf+tTHL49Zsv/rukPiDB2aURyl5/0sycACXTFENyyO4 djgvUsGbtrdGv5CcZOn36wFOPveF+kbkt2pQ19n+dizsWy0gv8WuLHqsTP+bF4svcEWByB9zm /edQsW9iDoAhCR3uCt9YGvtcStr/qQTg8yPd4VgGQWSTnmPqdFnjzOdvcM5Q792pF4reVEcmp EQzHdBY43F4r/vYQnzciplIbG9lseqIg95mse0p6alrytouUSlyd4PnmFhcUrkmsfzPhytLyZ G99RC6MasYTWC44uNwkIoM8EGraGQmMQVHtZ81YhSVLmQKXgRYD4PtMxXZ4UN7b5Ozh1/vuAM pI7GD7XTIY+YiZ5Q6sy+zcrdGtNIZsXLB+VW1DIgPUOSyY6t1/giAeq/6IOdldPQrWatG505U 47aw4Sc8xjnDbVAkaS6G4+Tl9kYZdZEBFwMOY6d6LsIdrP188of+J+59IyD8r2OCae+rBbisZ yg6qomLZGNivxWiJlT4UhlDBWJmdhvswC+JTYACm2/sOdvpaoEh/Aw1nro3O1TR8TJx3cGYmF NWW/lMfuuGJ7cZXHTvN4IjkEZ0gprE9Fapa6t8IxRiCvLjMMXQfBkN7mYzlRKEwEPCkMVH9+M 05NDGmv X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 1/21/16 7:07 PM, mgbii bax wrote: > We were hit by some interesting addition to systemd, it appears that > logging in/out to the machine with the user account used to start the > postgres service has some catastrophic effect. A systemd process deleted > Postgresql.NNNN file in /dev/shm (tmpfs). The documentation of systemd states that this only happens for non-system users. Can you check whether your "postgres" user (or whatever you are using) is a system user? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin