Hello,

psql -U odoo -d test_init -f test_init.sql

This command is try to connect with postgresql database using user "odoo". But you have not define this user/role for postgresql database.

Please first create user/role named "odoo" and then try to connect using that user.