Odoo Help


can't restore .sql database why? help ??

on 5/25/16, 6:56 AM 772 views

when I use this :

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

I get this error:

psql: FATAL: Peer authentication failed for user "odoo"

how can I fix this ???

I use new odoo installation debian, odoo8

Juan Vicente Pascual
On 5/25/16, 7:06 AM

try this,

sudo su postgres

createdb test_init -O odoo

psql -d test_init -f test_init.sql

Kind regards,




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.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/25/16, 6:56 AM
Seen: 772 times
Last updated: 5/25/16, 7:45 AM