Re: BUG #13959: Missing tmpfile exclude conf for socket - Mailing list pgsql-bugs

From Devrim Gündüz
Subject Re: BUG #13959: Missing tmpfile exclude conf for socket
Date
Msg-id F2B9C013-C86B-4F57-9390-91A6613FE8F2@gunduz.org
Whole thread Raw
In response to BUG #13959: Missing tmpfile exclude conf for socket  (jsosic@gmail.com)
Responses Re: BUG #13959: Missing tmpfile exclude conf for socket
List pgsql-bugs
Hi,

Community RPMs already provide this:

http://git.postgresql.org/gitweb/?p=pgrpms.git;a=tree;f=rpm/redhat/9.4/postgresql/EL-7;h=7f86e648aef233c660b95c14dc97bc914c76cf81;hb=HEAD

...and also ve store the socket also under /var/run/postgresql directory.

Which RPMs are you using?

Regards, Devrim

On February 14, 2016 12:53:37 AM GMT+02:00, jsosic@gmail.com wrote:
The following bug has been logged on the website:

Bug reference: 13959
Logged by: Jakov Sosic
Email address: jsosic@gmail.com
PostgreSQL version: 9.4.1
Operating system: CentOS 7
Description:

Systemd on EL7 and probably some Debian based distributions has service
called systemd-tmpfiles-clean. That service deletes everything from /tmp
that's not excluded via special files.

PgSQL stores socket under /tmp by default, and systemd-tmpfiles-clean can
actually delete it. To avoid this, PGSQL packages should bring a file which
excludes it's socket from being deleted by tmpfiles-clean.

This is an example of file:

cat >> /usr/lib/tmpfiles.d/postgresql.conf <<EOF
# systemd tmpfiles exclude file for pgsql
# pgsql software unfortunately stores some important files
# in /tmp which should not be deleted

# Exclude pgsql socket and lock files
x /tmp/.s.PGSQL.*
EOF


--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #13938: CAST error on Index "function must be immutable"
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #13958: Missing docs on error