Search Postgresql Archives

Re: How to make PostreSQL utilities honor home directories?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux