Setup a PostgreSQL user for Odoo [OpenERP] in Ubuntu

Odoo use PostgreSQL as database.

Here you will find the how to setup a postgresql user for odoo in ubuntu.

So follow the steps as below.

Install the required packages

• First of all start the terminal.

• Enter following command to install postgresql package

• >>> sudo apt-get install postgresql

• For graphical  interface of postgresql use the following command

• >>> sudo apt-get install pgadmin3

Setup a PostgreSQL user for Odoo

Now for the communication between odoo client and postgresql we have to create user.

• So first of all go to terminal and type following command

• >>> sudo su postgres

• Now create PostgreSQL user XXXX using the following command:

• >>> createuser --createdb --username postgres --no-createrole --pwprompt XXXXX

• where XXXX name will be same system user

• like if your teminal is like below

• hitesh@htr:/$  

• then choose “hitesh” as username.

• Now when you enter above command it will ask for password ,provide the password as you like 

• >>>Enter password for new role: XXXXXXXXXX

• >>>Enter it again: XXXXXXXXXX

• Then it will ask for super user then provide “y” and press enter

• >>> Shall the new role be a superuser? (y/n)  y

• Now User get created and last thing you have to do is provide following command

• >>> createdb stable --encoding=UNICODE

• >>> Exit

To access your database using pgAdmin III

You must configure the database connection as shown in the following figure:

• For that open pgadmin3 and follow the steps as given in below image.

Now you can enjoy with odoo......!!!!!!!