From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | noloader(at)gmail(dot)com |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: How to make PostreSQL utilities honor home directories? |
Date: | 2022-09-01 22:16:14 |
Message-ID: | 780195.1662070574@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jeffrey Walton <noloader(at)gmail(dot)com> 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
You've left out quite a lot of information here ... like what
connection that directory has to do with anything. Is it your
current directory when you invoke this command?
If so, a plausible explanation is that psql is trying to chase a
symlink to somewhere, which involves some chdir's so it can resolve
the symlink correctly, and afterwards it has to change back to
where it started --- which would fail if it can't look up that
directory.
Why it's trying to resolve a symlink isn't apparent though.
Is the "psql" you're invoking a symlink to somewhere?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2022-09-01 22:58:47 | Re: How to make PostreSQL utilities honor home directories? |
Previous Message | Adrian Klaver | 2022-09-01 22:06:02 | Re: How to make PostreSQL utilities honor home directories? |