Setup Postgre untuk Odoo

Required step for Instalasi Odoo

Windows

Setup postgree for odoo:

1. Add PostgreSQL’s bin directory (by default: C:\Program Files\PostgreSQL\version>\bin) to the PATH.
2. Create a postgres user with a password using the pg admin gui:
   1. Open pgAdmin.
   2. Double-click the server to create a connection.
   3. Select Object ‣ Create ‣ Login/Group Role.
   4. Enter the username in the Role Name field (e.g., odoo).
   5. Open the Definition tab, enter a password (e.g., odoo), and click Save.
   6. Open the Privileges tab and switch Can login? to Yes and Create database? to Yes.

Linux

sudo -u postgres createuser -d -R -S $USER
createdb $USER