From: | Amn Ojee Uw <amnojeeuw(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Cc: | haramrae(at)gmail(dot)com |
Subject: | Re: Nu-B here |
Date: | 2023-07-25 22:10:24 |
Message-ID: | 32575904-99e1-bd87-4bda-c55fb7eea9b6@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)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.
>>
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Abhishek Bhola | 2023-07-26 02:00:30 | Re: Difference in the tablespace folders on primary and secondary nodes |
Previous Message | Wen Yi | 2023-07-25 21:43:50 | logging_collector is off, but the logging is opening |