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