Обсуждение: BUG #13959: Missing tmpfile exclude conf for socket
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
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
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
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.
On 02/15/2016 06:19 PM, Devrim Gündüz wrote: > 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? > I was on 9.4.1... Looking at the SPEC file in the link you provided it seems you guys fixed this bug in 9.4.2: ``` Source19: postgresql.tmpfiles.d` ``` ``` * Fri May 22 2015 Devrim Gündüz <devrim@gunduz.org> - 9.4.2-2PGDG - Create and own /var/run/postgresql directory. Per report from Pete Deffendol. ``` So I guess you can ditch the bug report... Sorry for spam :(