Bug 1992263

Summary: postgresql:10/postgresql: tmpfiles config is using deprecated path, causing a warning to be logged
Product: Red Hat Enterprise Linux 8 Reporter: Bill Yodlowsky <byodlows>
Component: postgresqlAssignee: Filip Januš <fjanus>
Status: CLOSED ERRATA QA Contact: Vaclav Danek <vdanek>
Severity: low Docs Contact:
Priority: unspecified    
Version: 8.4CC: databases-maint, fjanus, hhorak, ljavorsk, mkulik, pkubat, praiskup
Target Milestone: betaKeywords: EasyFix, Reproducer, Triaged
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: postgresql-10-8060020211108140204.d63f516d Doc Type: No Doc Update
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2022-05-10 13:47:23 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Bill Yodlowsky 2021-08-10 20:20:23 UTC
Description of problem:

All postgresql streams ship a postgresql-server package with a deprecated path in /usr/lib/tmpfiles.d/postgresql.conf, causing systemd to complain in the logs.

-- default modular stream postgresql:10 --
[root@46b401145e03 /]# rpm -q postgresql-server && cat /usr/lib/tmpfiles.d/postgresql.conf 
postgresql-server-10.17-1.module+el8.4.0+11249+895597ab.x86_64
d /var/run/postgresql 0755 postgres postgres -

-- stream postgresql:9.6 --
[root@46b401145e03 /]# rpm -q postgresql-server && cat /usr/lib/tmpfiles.d/postgresql.conf
postgresql-server-9.6.22-1.module+el8.4.0+11244+beebcf7e.x86_64
d /var/run/postgresql 0755 postgres postgres -

-- stream postgresql:12 --
[root@46b401145e03 /]# rpm -q postgresql-server && cat /usr/lib/tmpfiles.d/postgresql.conf
postgresql-server-12.7-1.module+el8.4.0+11288+c193d6d7.x86_64
d /var/run/postgresql 0755 postgres postgres -

-- stream postgresql:13 --
[root@46b401145e03 /]# rpm -q postgresql-server && cat /usr/lib/tmpfiles.d/postgresql.conf
postgresql-server-13.3-1.module+el8.4.0+11254+85259292.x86_64
d /var/run/postgresql 0755 postgres postgres -


Version-Release number of selected component (if applicable):

postgresql-server-10.17-1.module+el8.4.0+11249+895597ab.x86_64
postgresql-server-9.6.22-1.module+el8.4.0+11244+beebcf7e.x86_64
postgresql-server-12.7-1.module+el8.4.0+11288+c193d6d7.x86_64
postgresql-server-13.3-1.module+el8.4.0+11254+85259292.x86_64


How reproducible:


Steps to Reproduce:
1. dnf module enable postgresql:{9.6,10,12,13}
2. dnf -y install postgresql-server
3. cat /usr/lib/tmpfiles.d/postgresql.conf
4. systemd-tmpfiles will log the deprecation warning


Actual results:

[/usr/lib/tmpfiles.d/postgresql.conf:1] Line references path below legacy directory /var/run/, updating ...; please update the tmpfiles.d/ drop-in file accordingly."

Expected results:

no warning

Additional info:

Comment 1 mkulik 2021-09-07 15:50:44 UTC
Fix from fedora upstream waiting for review and merge into RHEL8.6.

Comment 7 Filip Januš 2021-11-15 13:53:41 UTC
*** Bug 1970249 has been marked as a duplicate of this bug. ***

Comment 11 errata-xmlrpc 2022-05-10 13:47:23 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Moderate: postgresql:10 security update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2022:1830