On 9/1/22 3:01 PM, Jeffrey Walton wrote:
Hi Everyone,
We are having a heck of a time getting PostreSQL utilities to honor
home directories. For example, when I execute this script:
sudo -H -u postgres PGPASSWORD=${password} \
psql -h "${hostname}" -U "${username}" -d "${database}" \
--command="..."
It produces failures:
could not change directory to "/home/jwalton/godojo": Permission denied
What if you add -i?:
sudo -H -u postgres -i ...
/home/jwalton is my home directory. The postgres user does not have
access to my stuff. The postgres user's home directory is
/var/lib/pgsql .
Reading through the `psql --help` options and searching on the web is
not turning up any hits.
We are also observing the errors when using pg_isready .
How to make PostreSQL utilities honor home directories?
Thanks in advance.
Jeff
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
