On 2022-09-01 20:49:56 -0400, Jeffrey Walton wrote: > On Thu, Sep 1, 2022 at 8:23 PM Peter J. Holzer <[email protected]> wrote: > > > > On 2022-09-01 18:16:14 -0400, Tom Lane wrote: > > > Jeffrey Walton <[email protected]> writes: > > > > 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
> > I get the same behaviour. So it seems that psql changes to its basedir
> > and then can't change back again.
>
> I guess there is no way to avoid the problem.
Changing to /tmp (or some other directory accessible by posgres) before
running the script would avoid it.
As would (temporarily) changing the permissions of the diretor(y/ies).
Or not using sudo at all (see other messages).
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | [email protected] | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
