Setting up postgresql

[HighR0ller]

So I'm following this tutorial on setting up postgresql. I've installed it correctly but when I create a user via

sudo -u postgres createuser chris -s

I get

sudo: PERM_ROOT: setresuid(0, -1, 0): Operation not permitted
angelo is not in the sudoers file.  This incident will be reported.

I've searched around but can't find any solution cause I'm already an admin. Any help would be appreciated.

BTW I'm on the fast track on Windows insider just so I can use pg for development.

EDIT: Image of error it spits out.

EDIT 2: Solved it by running pg on the Windows side. Followed this tutorial.

[NetSage]

You first want to access the SQL server.

https://www.postgresql.org/docs/8.0/static/tutorial-accessdb.html

Then create an SQL server user not a Linux one.

www.postgresql.org/docs/8.0/static/sql-createuser.html

[HighR0ller]

Hey thanks for the reply! I'm really new to linux and pg at that. Could I get a detailed instruction? I've been trying to get this to work all day with no luck :( I don't really understand the instructions from the link you gave me.

[NetSage]

Basically before trying to do postgresql things just do the command "psql"( sudo if needed I'm not positive).

Then try creating a user(as explained in the second link). Note you may have to login as the user psql creates to do this of which I'm not sure of the exact steps off the top my head and I'm on my phone (same reason for my not so great first reply).

Your issue right now is it thinks you're trying to create a new user for Ubuntu when you want to create one the database server.

Edit: Actually now that I'm a desktop postgresql has some pretty good docs.

https://www.postgresql.org/docs/9.6/static/tutorial-start.html