Re: error on connecting port 5432

On 12/1/20 8:10 AM, Atul Kumar wrote:
> 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.

No you are not at root for the OS you are at OS user postgres connecting 
as database user testuser.


> 
> Error screenshots are already shared with you.

What I was saying is that the error message as text is better. You can 
copy and paste from a terminal session.

You have not answered the other questions about the status of your 
Postgres install(s). The suspicion is that you have a mixed install and 
are having PATH issues. See Tom's response also.

> 
> Please re-check the same.
> 
> 
> 
> 
> 
> Regards
> Atul
> 
> 
> 
> On Tuesday, December 1, 2020, Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com