Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save ekumachidi/aac9316496fb2ca84dcef00920fede9b to your computer and use it in GitHub Desktop.
Save ekumachidi/aac9316496fb2ca84dcef00920fede9b to your computer and use it in GitHub Desktop.
Create new postgres super user
Run this
"sudo -u postgres psql"
in your terminal to get into postgres
postgres=#
Run "CREATE USER new_username;"
Note: Replace new_username with the user you want to create,
postgres=# CREATE USER new_username;
CREATE ROLE
Since you want that user to be able to create a DB, you need to alter the role to superuser
postgres=# ALTER USER new_username SUPERUSER CREATEDB;
ALTER ROLE
To confirm, everything was successful,
postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
new_username | Superuser, Create DB | {}
postgres | Superuser, Create role, Create DB, Replication | {}
root | Superuser, Create role, Create DB | {}
postgres=#
@miladj3
Copy link

miladj3 commented Jul 5, 2021

thank youuu

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment