PostgreSQL server

Axelor recommends installing a PostgreSQL database 9+ data.

Installing Packages

Run the following command to install the package postgresql :

$ sudo apt-get install postgresql-9.1

Creating a User

When the installation is complete, you must create a user. This user will be used by the application to connect to the database. The default superuser for PostgreSQL is called postgres . You must log in as that user first and create a user, for example Axelor.

Begin to log in as the user postgres :

$ sudo -i -u postgres

Then, run the following command to create the user Axelor PostgreSQL for application:

$ createuser --createdb --username postgres --createrole --pwprompt axelor

Explanations:

• --createdb : The new user will be able to create new databases
• --username postgres : createuser will use the postgres user (superuser)
• --no-CREATEROLE : The new user will not be able to create new users
• --pwprompt : createuser will ask for the password of the new user
• Axelor : The name of the new user

Configuring pgAdmin III

The pgAdmin III GUI installs with the following command:

$ sudo apt-get install pgadmin3

To access your database using pgAdmin III, you must configure the connection to the database as shown in the following figure: