Re: [PG19-3 PATCH] Don't ignore passfile

From: Umar Hayat <postgresql(dot)wizard(at)gmail(dot)com>
To: postgresql(dot)cache976(at)passmail(dot)net
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PG19-3 PATCH] Don't ignore passfile
Date: 2025-09-04 04:25:00
Message-ID: CAD68Dp16ucP0yVe9sMnO2jKF-gj3=FvPJS1OZUS14XjHk6LagQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
I haven't reviewed your patch, Not sure what would be expected
behaviour but the current one is documented in PostgreSQL
documentation [1], so there should not be any surprises for users.
"On Unix systems, the permissions on a password file must disallow any
access to world or group; achieve this by a command such as chmod 0600
~/.pgpass. If the permissions are less strict than this, the file will
be ignored. On Microsoft Windows, it is assumed that the file is
stored in a directory that is secure, so no special permissions check
is made."

Maybe it should be highlighted in documentation as a *Note* to put
some more emphasis?

[1] https://www.postgresql.org/docs/current/libpq-pgpass.html

--
Umar Hayat
SKAI Worldwide (https://skaiworldwide.com/)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2025-09-04 04:35:36 Re: Should io_method=worker remain the default?
Previous Message Shinya Kato 2025-09-04 04:13:09 Re: Add log_autovacuum_{vacuum|analyze}_min_duration