Failing to create database with `odev create <db>` method

[chid-odoo]

Criticality

Blocking

What happened?

After installing I am receiving the following error output with odev create

odev ) odev create test-db
[!] Database 'test-db' already exists                                                                                                       
[?] Overwrite it? Yes
[-] Failed to install 'pgvector' extension, please ensure it is installed on your system and whitelisted with pgextwlist                    
[-] Failed to create database 'test-db'   

I have followed the steps here https://github.com/pgvector/pgvector to install the pgvector extension in my postgresql

pgvector ) sudo -u postgres psql
psql (16.11 (Ubuntu 16.11-0ubuntu0.24.04.1))
Type "help" for help.

postgres=# CREATE EXTENSION vector;
ERROR:  extension "vector" already exists
postgres=# 

Are there additional steps to take here? I see the output from the error mentioning I need to whitelist but that step is not listed in the installation steps

Relevant log output

What is expected?

Should be able to create the database without error output

Possible implementation

No response

Additional information

pgvector ) pg_config --version
PostgreSQL 16.11 (Ubuntu 16.11-0ubuntu0.24.04.1)

pgvector ) python --version
Python 3.12.3

[brinkflew]

Hi @chid-odoo

Indeed, by default vector is marked as unsafe and can only be enabled on a database by a superuser (i.e. postgres).

We used this external extension to whitelist vector so it can be enabled by your user locally: https://github.com/dimitri/pgextwlist

The setup is not straightforward but it's a one shot and will work for all databases in the future.

I have followed the steps here https://github.com/pgvector/pgvector to install the pgvector extension in my postgresql

Note that the extension needs to be installed once on the system (the binaries, installed with system packages, you already did that) and then it must be activated on a per-database basis (CREATE EXTENSION vector; is not global). Odev does that for you, you're only missing the whitelisting part I linked above.