From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Atul Kumar <akumar14871(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: error on connecting port 5432 |
Date: | 2020-12-01 14:26:52 |
Message-ID: | 2e7b686b-7f1a-d5f9-75d8-c7a754798789@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Adrian Klaver | 2020-12-01 14:32:11 | Re: error on connecting port 5432 |
Previous Message | mobigroup | 2020-12-01 10:34:28 | Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK |