From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: rvpostgres@metaways.de
Subject: BUG #17649: With libpg5 15.0 psql 10.22 uses HOME variable instead of uid and /etc/passwd to select .pgpass file
Date: Tue, 18 Oct 2022 09:17:05 +0000
Message-ID: <17649-ac7350cba2628cf7@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17649
Logged by: Reinhard Vicinus
Email address: rvpostgres@metaways.de
PostgreSQL version: 15.0
Operating system: Ubuntu 18.04
Description:
This is probably the same issue that was reported in bug #17647
The general postgresql version we use is 10.22-1.pgdg18.04+1
With the update of libpg5 from 14.5-1.pgdg18.04+1 to 15.0-1.pgdg18.04+1 the
behavior of psql changed and with libpg5 version 15.0 it uses the HOME
environment variable to determine the location of the .pgpass file. With
14.5 the uid of the running process is used to determine the home directory
location. This causes the issue that "sudo -u postgres psql" no longer finds
the .pgpass file in /var/lib/postgresql/. After downgrading libpg5 to
14.5-1.pgdg18.04+1 or setting the correct HOME environment variable, it
works again as intended.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, rvpostgres@metaways.de
Subject: Re: BUG #17649: With libpg5 15.0 psql 10.22 uses HOME variable instead of uid and /etc/passwd to select .pgpass file
In-Reply-To: <17649-ac7350cba2628cf7@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox