Re: error on connecting port 5432

On 12/1/20 6:26 AM, Adrian Klaver 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?

Does /var/run/postgresql/.s.PGSQL.5432 exist?

> 
> 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