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

From Alban Hertroys
Subject Re: Nu-B here
Date
Msg-id 975DAA29-FD15-4B1D-B19C-297725A59D74@gmail.com
Whole thread Raw
In response to Nu-B here  (Amn Ojee Uw <amnojeeuw@gmail.com>)
Responses Re: Nu-B here  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
> On 20 Jul 2023, at 02:36, Amn Ojee Uw <amnojeeuw@gmail.com> 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 database named postgres as database user postgres, you can instead use the
command'psql -U postgres postgres’. 

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.




pgsql-general by date:

Previous
From: Anthony Apollis
Date:
Subject: Postgres SQL
Next
From: gzh
Date:
Subject: How to improve the performance of my SQL query?