PostgreSQL database: Watch it!

PostgreSQL database

Openbravo ERP supports PostgreSQL as its database engine.

• For performance reasons, Openbravo recommends PostgreSQL 8.3.x instead of versions 8.2.x and 8.1.x
  
• PostgreSQL versions 8.2.7 and 8.3.1 have a serious issue with DBSourceManager. Do not use them.
  

PostgreSQL documentation and tutorials are available from:

• PostgreSQL Documentation
  
• Postgres rocks documentation

Debian (Ubuntu/Kubuntu/Linux Mint)

1. Install the package using:
   

   sudo apt-get install postgresql-8.3

   
   
2. Set the postgres password using:

   sudo su - postgres -c psql

   alter role postgres with password 'new_password';

   \q