Re: Nu-B here

2023-07-25 Thread Amn Ojee Uw
Please note the following : /psql (12.15 (Debian 12.15-1.pgdg120+1 /Thanks in advance // On 7/20/23 10:41 a.m., Adrian Klaver wrote: On 7/19/23 23:32, Alban Hertroys wrote: On 20 Jul 2023, at 02:36, Amn Ojee Uw wrote: After this command 'sudo -u postgres psql' I get this message : could not

Re: Nu-B here

2023-07-20 Thread Adrian Klaver
On 7/19/23 23:32, Alban Hertroys wrote: On 20 Jul 2023, at 02:36, Amn Ojee Uw wrote: After this command 'sudo -u postgres psql' I get this message : could not change directory to "/home/my_account": Permission denied What’s the reason that you’re using the OS user postgres? Because the De

Re: Nu-B here

2023-07-19 Thread Alban Hertroys
> On 20 Jul 2023, at 02:36, Amn Ojee Uw wrote: > > After this command 'sudo -u postgres psql' > I get this message : > could not change directory to "/home/my_account": Permission denied What’s the reason that you’re using the OS user postgres? If you’re simply trying to connect to the datab

Re: Nu-B here

2023-07-19 Thread Maciek Sakrejda
On Wed, Jul 19, 2023, 17:36 Amn Ojee Uw wrote: > 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.* > > I tried using help, but to no avail.

Re: Nu-B here

2023-07-19 Thread Tom Lane
Amn Ojee Uw 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 d

Nu-B here

2023-07-19 Thread Amn Ojee Uw
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.* I tried using help, but to no avail. What am I doing wrong? Thanks in advance!