Odoo Help


posgresql fatal error: password authentication failed for user "opengp"

on 5/29/13, 5:27 AM 9,516 views

I have installed open-ERP7 all in one.

I uninstalled it and when i tried installing again I have been having issues with postgresql database.

When I open openERP I get a server error; "OperationalError: FATAL: password authentication failed for user "openpg"

When I access my postgresql server through pgAdmin III I get the same error: "password authentication failed for user "opengp""

I have tried to install and install openERP as well as postgresql db but I'm not getting a solution. any help.

I am using windows 7 64 bit

what password did you tried

on 5/29/13, 6:22 AM

Name: lohalhost host: localhost port: 5432 Maintainance DB: postgres Username: openerp password: openpgpwd server information.

on 5/29/13, 6:29 AM
Amit Parik (amp)
On 5/29/13, 7:28 AM

Hello Titus,

The problem is we can't completely remove the postgres on windows.That's why this problem is occurs.

I think when you was install all in one you didn't check the check box for postgres or you was install postgres first then try to run OpenERP all in one.

What I suggest open the control panel and remove the all packages of postgres then after try to run setup.exe with check that postgres checkbox.

Hope this will help.

Thank you!

Thankyou Amit. I unistalled both the postgresql and the openerp. But now when I try installing the openerp on the window to select the components to install the option for postgresql is inactive (I cant select). When I install postgres on its own I get three servers, one has openpg as the owner but does not take openpgpwd as the password. I have been trying for the last four days. any suggestions?

on 5/30/13, 3:36 AM
On 5/30/13, 9:47 AM

I was able to resolve my problem. After unistalling openERP and postgresql I removed all postgres related keys from windows registry.

I was able to install openerp again.

On 5/30/13, 10:27 AM

Try this way Name: localhost host: localhost port: 5432 Maintainance DB: postgres Username: openerp password: openpgpwd server information.

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

0 follower(s)


Asked: 5/29/13, 5:27 AM
Seen: 9516 times
Last updated: 3/16/15, 8:10 AM