How to create a new user after initializing a database for first time

Do the following :

su -

su - poatgres

createuser -d //-d give user to permission to create a new database

exit

after that you may create a database which is owned by above user

createdb -O

then you may dump a database owned by the above mentioned user

hopes this will work. Good luck