Re: Nu-B here

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 <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?
>
> Because the Debian/Ubuntu packaging sets up pg_hba.conf to use peer 
> auth for local connections and the only database user created is 
> postgres.
>
> See:
>
> https://ubuntu.com/server/docs/databases-postgresql
>
> for more information.
>
>>
>> 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.
>>
>>
>>
>