openbravo: conecting to postgresql

For regular configuration you will need to connect to the PostgreSQL, some of the basic programs you will be connecting from are:

• Jasper Reports (Ireport)
• A GUI Desktop Database Manager (PgAdmin)
• Jasper Server

To resolve this you will need to add the IP where you'll be connecting from to the pg "firewall"

The pg_hba.conf file to be edited is the following:

/etc/postgresql/8.4/openbravo-3/pg_hba.conf

host                    all                      all              XX.XX.XX.XXX/24                md5