Re: How to make PostreSQL utilities honor home directories?

On Thu, Sep 1, 2022 at 4:09 PM Peter <pmc(at)citylink(dot)dinoex(dot)sub(dot)org> wrote:

>
> ! It produces failures:
> !
> ! could not change directory to "/home/jwalton/godojo": Permission
> denied
>
> ... this appears to me as rather a sudo issue. Because certainly
> psql cannot execute /as user postgres/ in a directory where user
> postgres is not allowed to enter.

FWIW, I don't think this is quite true, and it's more of a warning than a
failure. For example, from my own directory I can sudo to postgres and run
a psql shell with no problem. It will complain about not being able to
change directory, but it will then proceed to load and run psql just fine...

[ktanzer(at)hosting ~]$ sudo -u postgres psql
could not change directory to "/home/ktanzer": Permission denied
psql...

Cheers,
Ken

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.