Documentation of .pgpass for Unix is incomplete

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: marc(at)msys(dot)ch
Subject: Documentation of .pgpass for Unix is incomplete
Date: 2024-08-08 09:44:51
Message-ID: 172311029184.915368.14898011794686876553@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/libpq-pgpass.html
Description:

The documentation of the .pgpass password file is incomplete in the Unix
case (https://www.postgresql.org/docs/16/libpq-pgpass.html)

It does not mention how the .pgpass File is actually found. One would
assume it uses the getpwent() function to find the current users
homedirectory and locate the .pgpass file there, but this is not the case.
It only looks at the HOME environment variable.

If you change the user using setuid() and do not change HOME as well, the
file not be found. Or assume you start a DB client as root by using su to
change the user id, things will not work:

# /bin/su -c "startx -- " - xpos

This starts X11 and changes to the user xpos, but it does only change the
user id, not $HOME.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David Rowley 2024-08-12 02:19:06 Re: A minor bug in doc. Hovering over heading shows # besides it.
Previous Message PG Doc comments form 2024-08-08 08:42:33 Managing SSL Connections