Search code examples
postgresqlubuntupgadminopenbravo

Openbravo - Connecting pgadmin with postgresql database in Ubuntu


I have installed Openbravo ERP 3.0 in Ubuntu 12.04(LTS). After completed the installation I tried to connect with postgresql database using pgadmin 9.1. I gave all the details as mentioned in this link: http://wiki.openbravo.com/wiki/Installation/Appliance/Openbravo.

Also I have changed the config file settings like listen_addresses="*". I got this error after I click "Ok" button

enter image description here

Could anyone give suggestion to fix this error? Thanks in advance.


Solution

  • Actually the problem comes because of not mentioning the local cluster or data area for PostgreSQL. To do this after installing Openbravo, need to give this command in terminal

    psql -d openbravo -U tad -h localhost -p 5932

    Finally give the PostgreSQL configuration details as mentioned in this link

    It works fine now...