Create the same postgres user as the linux user

gistfile1.md

First, switch to the postgres system user account

sudo su - postgres

To create a user, type the following command(Enter the same user and password as the Linux user)

createuser --interactive --pwprompt

Bonus: Show user

\du

delete user

drop user user_name;