Sunday, April 29, 2012

Client access / pgadmin access

In " var/lib/pgsql/data" edit the file  "pg_hba.conf" and add
 host    all         all         192.168.21.237/24        trust


also edit the file "postgresql.conf"  to refelect
 listen_addresses = '*'   

Tables which should not be used as any custom table

    A_ - asset management
    AD_ - application dictionary
    C_ - core functionality
    FACT_ - accounting (general ledger postings)
    FIN_ - financial management
    GL_ - general ledger
    I_ - import
    M_ - material management
    MA_ - manufacturing
    MRP_ - material resource planning
    R_ - request (CRM functionality that is deprecated now)
    S_ - services
    OB - Openbravo owned modules


The above prefixes belong to the core of Openbravo and should not be used by any custom tables.