From: | Atul Kumar <akumar14871(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: error on connecting port 5432 |
Date: | 2020-12-01 16:10:38 |
Message-ID: | CA+ONtZ4AgtE1w+mSWb8h_r_fyoC3wj05Fd3czC136zU+6Y1V5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Just to clarify that I am at root OS user, trying to create a test user
using postgres user(-u) with create user command.
Error screenshots are already shared with you.
Please re-check the same.
Regards
Atul
On Tuesday, December 1, 2020, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 12/1/20 12:51 AM, Atul Kumar wrote:
>
>> Hi,
>>
>> When I m creating a test db user using below command using root OS user
>> sudo -u postgres createuser -p 5432 --pwprompt testuser
>>
>> I am getting the attached error of port.
>>
>> But my postgres services are running fine on port 5432, I am sharing
>> the screenshot of that also.
>>
>
> In future please include this as text not images.
>
>
>> So please help me in letting me know why I am getting the above error
>> when I am connected to the root OS user?
>>
>
> You are not connecting as OS root you are connecting as the database user
> testuser.
>
> Does /var/run/postgresql/.s.PGSQL.5432 exits?
>
> Do you have more then one instance of Postgres on this machine?
>
> If so how where they installed and more importantly where they installed
> differently?
>
> As a test try running the command with addition of -h localhost.
>
>
>> Note - I am able to create a test db user when I am connected to
>> postgres using psql command.
>>
>>
>> Regards,
>> Atul
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2020-12-01 16:14:28 | Re: AW: FDW using remote ODBC driver |
Previous Message | Hemil Ruparel | 2020-12-01 15:28:41 | Re: FDW using remote ODBC driver |