PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15596
PG Version11.1
OSDebian testing
Opened2019-01-17 01:48:30+00
Reported byAntoine Amarilli
StatusWon't Fix

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15596
Logged by:          Antoine Amarilli
Email address:      (redacted)
PostgreSQL version: 11.1
Operating system:   Debian testing
Description:        

Hi,

I was trying to install a PostgreSQL extension (namely,
https://github.com/PierreSenellart/provsql). This extension uses the macros
in the file /usr/lib/postgresql/11/lib/pgxs/src/makefiles/pgxs.mk to install
itself, so running "make install" does the following:

/bin/mkdir -p '/usr/lib/postgresql/11/lib'
/bin/mkdir -p '/usr/share/postgresql/11/extension'
/bin/mkdir -p '/usr/share/postgresql/11/extension'
/bin/mkdir -p '/usr/share/doc/postgresql-doc-11/extension'
/usr/bin/install -c -m 755  provsql.so
'/usr/lib/postgresql/11/lib/provsql.so'
/usr/bin/install -c -m 644 .//provsql.control
'/usr/share/postgresql/11/extension/'
/usr/bin/install -c -m 644 .//sql/provsql--1.0.0-dev.sql 
'/usr/share/postgresql/11/extension/'
/usr/bin/install -c -m 644 .//doc/provsql.md
'/usr/share/doc/postgresql-doc-11/extension/'
/bin/mkdir -p '/usr/lib/postgresql/11/lib/bitcode/provsql'
/bin/mkdir -p '/usr/lib/postgresql/11/lib/bitcode'/provsql/src/
...

However, the umask of my user is 077, so these "mkdir -p" invocations are
creating folders that can only be read by root, which is not the intended
behavior.

Would it be possible to fix this by redefining MKDIR_P="mkdir -m 0755 -p" in
pgxs.mk so that the mkdir invocations create the folders with the right
permissions, in line with the "install" invocations? Thanks!

Messages

DateAuthorSubject
2019-01-17 01:48:30+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15596: Folders created with wrong permissions when installing an extension with a non-default umask
2019-01-17 02:33:41+00Tom LaneRe: BUG #15596: Folders created with wrong permissions when installing an extension with a non-default umask
2019-01-17 10:05:36+00Antoine AmarilliRe: BUG #15596: Folders created with wrong permissions when installing an extension with a non-default umask