Odoo Help


cannot access pgadmin3 in ubuntu openerp

Joshua Levy
on 4/3/13, 10:53 AM 6,304 views


I seem to connect to the openpg database perfectly fine within windows and manage the openerp database. However in ubuntu I have installed pgadmin3 and tried to do the exact same thing, however I always get FATAL: incorrect password..

I would greatly appreciate some help on this...



Can you post a screenshot of your error and the log of software?

Francesco OpenCode
on 4/3/13, 11:37 AM

It's not really an OpenERP question. You could look at http://dba.stackexchange.com and find that the question has been answered there.

Lorenzo Cabrini
on 4/3/13, 11:49 AM

@Lorenzo Cabrini: Link or it did not happen

on 11/25/14, 9:39 AM
On 4/3/13, 12:25 PM

try accessing the database with pgadmin from a different machine. Looks like you have a problem with the username and password. You can find further information here:


With the standard installation of OpenERP remote connections are not allowed. You first have to change the parameters. So this is impossible.

on 4/3/13, 1:52 PM
On 4/3/13, 11:57 AM

I assume you have made your installations based on the standard installables. Last year I had the same problem.

AFAIK the user and pasword for the windows setup and the ubuntu setup are different!

It is best to check the configuration file for the correct user and pasword to use.

Added later: For the versions I used it was:

  • Ubuntu: user= openerp pasword=postgres
  • Windows: user= openpg pasword=openpgpwd

For connection with pgAdmin:

  • Host: localhost
  • Port: 5432 SSL blank
  • Maintenance DB: postgres

If you try to make a remote connection you get standard a connection error. For security reasons this is not allowed. If you want to change this you need to change the configuration paramaters.

Hi, do you know what are the default username and password in ubuntu ? thanks

Joshua Levy
on 4/3/13, 12:07 PM
On 11/26/14, 6:21 AM

Joshua, in order to open PostgreSQL database from other machine you need to setup 3 things:

  • The database server need to listen to other addresses.  This configuration is set in postgresql.conf under the listen_addresses key.  If you want the database server to be accessible from anywhere you can put '*' in place of 'localhost'
  • You need to check that your user has access to the database server from a specific network (IP address) and what authentication method is configured for that connection.  The configuration is stored in pg_hba.conf.  Each uncommented lines (those without # in front) represent allowed access method.  The lines on the top take precedent over the lines below it.  Each line must be in the following format.  The file itself has explanation on how to configure an access.  The configuration is usually set at the strictest level by default.  Most of the time, it is safe and convenient to configure access using md5 method.
  • Once you have both configured correctly, you have to ensure that you follow the allowed access method.  md5 means that you need to supply the correct password, peer means that the password used will be the same as the OS password (which may not what you want).
On 11/26/14, 6:29 AM

Go to openerp-server.conf file( use this command ,sudo nano /etc/openerp-server.conf), open  and check the  username and passord .Login with this username and password in postggres

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: 4/3/13, 10:53 AM
Seen: 6304 times
Last updated: 3/16/15, 8:10 AM