create a super-user in postgres

$ sudo -u postgres psql -c "ALTER USER <user_name> PASSWORD '<new_password>';"

=# SELECT usename FROM pg_user;
=# ALTER USER <user_name> WITH SUPERUSER; ALTER ROLE
=# \du