Odoo Help


This community 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.


cannot access pgadmin3 in ubuntu openerp

Joshua Levy
on 4/3/13, 10:53 AM 5,196 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


| 5 3 6
Jakarta, Indonesia
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).


| 5 2 5
kerala, India

Working as a Odoo Functional and Technical Expert

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



| 2 1 4
Buenos Aires, Argentina

Python developer, big fan of sailing

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


| 5 6 9
Lisse, Netherlands
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 4/3/13, 10:53 AM
Seen: 5196 times
Last updated: 3/16/15, 8:10 AM