OpenBravo Ubuntu Jaunty Environtment (1) – PostgreSQL

The Database we will use are the PostgreSQL.

1. Install the package using:

   sudo apt-get install postgresql-8.3 postgresql-contrib
   
   Configuring postgresql.conf to use port 5432...
    * Starting PostgreSQL 8.3 database server                               [ OK ]

2. Install the package using:

   sudo su - postgres -c psql
   alter role postgres with password 'new_password';
   \q

3. pgadmin3 are my favourite tool for postgresql GUI administration.

   #sudo apt-get install pgadmin3

Tags: Jaunty, OpenBravo, pgAdmin3, PostgreSQL, Ubuntu