PostgreSQL is a powerful, open source object-relational database system (ORDBMS). Unlike other relational database systems, the SQL function enables PostgreSQL users to create unique operators, complex data types, aggregate functions, data type conversion roles, and other database objects.
Step 1: Install PostgreSQL on CentOS 7
Step 2: Initialize the Database
Step 3 : Start the Database
After start and enable the service
PostgreSQL Basic Setup
If you receive an error, you can set a valid shell on the user with the following command:
Next, you need to create a PostgreSQL user who uses the same name as the user you are creating already for Odoo:
Afterwards, perform the same command:
To change the password, use the below command where you add your new password instead of the NewPassword:
You can switch to the PostgreSQL client shell using:
Here you can check the list of available commands by typing h. You can use h followed by the command for which you need more information. To exit the environment you can type q.