Re: Nu-B here

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Amn Ojee Uw <amnojeeuw(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Nu-B here
Date: 2023-07-20 00:54:18
Message-ID: 465497.1689814458@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Amn Ojee Uw <amnojeeuw(at)gmail(dot)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

In response to

  • Nu-B here at 2023-07-20 00:36:27 from Amn Ojee Uw

Browse pgsql-general by date

  From Date Subject
Next Message Maciek Sakrejda 2023-07-20 00:55:49 Re: Nu-B here
Previous Message Amn Ojee Uw 2023-07-20 00:37:07 My 1st JDBC and PostgreSQL