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.kla...@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.kla...@aklaver.com >
