Re: Nu-B here - Mailing list pgsql-general

From Tom Lane
Subject Re: Nu-B here
Date
Msg-id 465497.1689814458@sss.pgh.pa.us
Whole thread Raw
In response to Nu-B here  (Amn Ojee Uw <amnojeeuw@gmail.com>)
List pgsql-general
Amn Ojee Uw <amnojeeuw@gmail.com> writes:
> After this command 'sudo -u postgres psql'
> I get this message :
> *could not change directory to "/home/my_account": Permission denied**
> **psql (12.15 (Debian 12.15-1.pgdg120+1))**
> **Type "help" for help.*

This is normal if you launch psql via "sudo -u postgres" in a directory
that the postgres user doesn't have permissions to read/chdir to.
psql will still start, but its working directory will not be what
you'd expect, so commands that involve local filesystem access might
misbehave.

We have a fix for this error report in the upcoming v16, but psql commands
that involve local filesystem access will still not act very nicely if
psql can't read your directory.

            regards, tom lane



pgsql-general by date:

Previous
From: Amn Ojee Uw
Date:
Subject: My 1st JDBC and PostgreSQL
Next
From: Maciek Sakrejda
Date:
Subject: Re: Nu-B here