PostgreSQL (server, psql, pgvector)

The database behind every Odoo instance. Odoo 20 requires PostgreSQL 16+; AI features on-premise need pgvector.

Official site: www.postgresql.org/download/
Licence: Free (PostgreSQL licence)

Install

Linux

sudo apt install -y postgresql postgresql-contrib   # Ubuntu 24.04 ships 16
# newer versions: add the PGDG apt repository from postgresql.org/download/linux/ubuntu

macOS

brew install postgresql@16 && brew services start postgresql@16

Windows

winget install -e --id PostgreSQL.PostgreSQL.16   # or the EDB installer

Use with Odoo

db_host, db_port, db_user, db_password in odoo.conf.
Workers × db_maxconn must fit max_connections.
Backups need the filestore too.

Open the PostgreSQL (server, psql, pgvector) room