I run this to create a root role (to match with my root user on ubuntu 20.04) so I don't have to switch to postgres user to use pg_restore.
root
postgres
pg_restore
sudo -u postgres createuser --interactive Enter name of role to add: root Shall the new role be a superuser? (y/n) y
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I run this to create a
rootrole (to match with myrootuser on ubuntu 20.04) so I don't have to switch topostgresuser to usepg_restore.