The PostgreSQL community debates ALTER SYSTEM

Posted Apr 9, 2024 4:57 UTC (Tue) by shironeko (subscriber, #159952)
Parent article: The PostgreSQL community debates ALTER SYSTEM

maybe I missed this, but what's the problem with setting postgres.auto.conf to read-only?

The PostgreSQL community debates ALTER SYSTEM

Posted Apr 9, 2024 6:44 UTC (Tue) by ringerc (subscriber, #3071) [Link] (2 responses)

The error message is crap and doesn't tell the user what's going on or why.

Personally I would've been fine with doing it by permission change and just providing a better error for ENOPERM that tells the admin it might be deliberately disabled.

The PostgreSQL community debates ALTER SYSTEM

Posted Apr 21, 2024 16:27 UTC (Sun) by aaronmdjones (subscriber, #119973) [Link] (1 responses)

Attempting to write to a read-only file results in `-EACCES' (not a typo) / "Permission denied". `-ENOPERM' is not a thing; `-EPERM' is but this is "Operation not permitted" which is instead returned when e.g. trying to delete an immutable file (not the same thing as a read-only file).

The PostgreSQL community debates ALTER SYSTEM

Posted Apr 23, 2024 1:09 UTC (Tue) by ringerc (subscriber, #3071) [Link]

Thanks for the correction. That was a -ENOCOFFEE.