Re: systemd deletes shared memory segment in /dev/shm/Postgresql.NNNNNN

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: mgbii bax <gezeala(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: systemd deletes shared memory segment in /dev/shm/Postgresql.NNNNNN
Date: 2016-01-24 19:03:52
Message-ID: 56A52018.1030001@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message SELCUK AYDIN 2016-01-25 12:02:55 Postgresql 9.3 Postgis 2.1
Previous Message Thorsten Schöning 2016-01-23 15:47:56 Questions regarding handling of Postgres' stats data in case of tmpfs