how-to-install-and-use-postgresql-on-ubuntu-18-04

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04 dell@dell-Inspiron-5575:~$ sudo -u postgres createuser --interactive [sudo] password for dell: Enter name of role to add: lggqzqoqpiicfq Shall the new role be a superuser? (y/n) y createuser: creation of new role failed: ERROR: role "lggqzqoqpiicfq" already exists dell@dell-Inspiron-5575:~$ sudo -i -u lggqzqoqpiicfq dell@dell-Inspiron-5575:~$ createdb test dell@dell-Inspiron-5575:~$ psql -d test psql (10.15 (Ubuntu 10.15-0ubuntu0.18.04.1)) Type "help" for help. test=# \conninfo You are connected to database "test" as user "dell" via socket in "/var/run/postgresql" at port "5432". test=# ALTER USER dell PASSWORD '1234'; ALTER ROLE test=# sudo passwd postgres test-# \q