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.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx
