Re: BUG #16915: use psql have error "could not change directory to "/root": Permission denied"

On Fri, Mar 5, 2021, at 6:34 AM, 陈剑华 wrote:
> Of course, I can
> Centos7 ~ # sudo -u postgres -i psql
> This account is currently not available.
I tested it and it prints the "permission denied" message. IMO your setup is
broken. The PGDG packages create a postgres user with a shell. The routine that
prints this message expects to chdir the current directory to validate the psql
path, however, due to sudo withouth a shell it cannot chdir the current
directory. It cannot happen if you use a shell (sudo -i).

> this is my issue
> https://github.com/ANXS/postgresql/issues/499
>
> my passwd:
> postgres:x:1000:1000::/var/lib/postgres:/sbin/nologin
PGDG packages create postgres user with a shell.

[root(at)centos7 ~]# grep postgres /etc/passwd
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash

Since, your setup is broken and that psql works even after this error, it is
hard to convince someone to fix this minor issue. I wouldn't even classify it
as a bug.

--
Euler Taveira
EDB https://www.enterprisedb.com/