AI-powered search (AI Answers) needs pgvector extension

[Teiluj]

Hi,

It seems that the "AI-powered search (AI Answers)" function needs the pgvector extension for Postgres to work.

Is it possible to include in the package?

Many thanks,

[james]

Hello @teiluj
Please include the output of cloudron-support --troubleshoot.

[Teiluj]

Hi @james

Here is the output:

Vendor: QEMU Product: Standard PC (Q35 + ICH9, 2009)
Linux: 6.8.0-110-generic
Ubuntu: noble 24.04
Execution environment: kvm
Processor: Intel(R) Xeon(R) Silver 4216 CPU @ 2.10GHz
BIOS pc-q35-10.0  CPU @ 2.0GHz x 8
RAM: 32866116KB
Disk: /dev/sda2       581G
[OK]    node version is correct
[OK]    IPv6 is enabled and public IPv6 address is working
[OK]    docker is running
[OK]    docker version is correct
[OK]    MySQL is running
[OK]    netplan is good
[OK]    DNS is resolving via systemd-resolved
[OK]    unbound is running
[OK]    nginx is running
[OK]    dashboard cert is valid
[OK]    dashboard is reachable via loopback
[OK]    No pending database migrations
[OK]    Service 'mysql' is running and healthy
[OK]    Service 'postgresql' is running and healthy
[WARN]  Service 'mongodb' is not running (may be lazy-stopped)
[OK]    Service 'mail' is running and healthy
[OK]    Service 'graphite' is running and healthy
[OK]    Service 'sftp' is running and healthy
[OK]    box v9.1.6 is running
[OK]    Dashboard is reachable via domain name

Are you looking for something in particular?

[james]

Hello @teiluj

@Teiluj said:

Are you looking for something in particular?

Wanted to ensure that the troubleshooting command looks all good and the Cloudron version is not many versions back.
I will have to look into it why pgvector is missing for docmost.

[Teiluj]

Makes sense - thanks a lot!

[joseph]

It seems the AI feature is only available with paid plans. From what I read at https://docmost.com/docs/self-hosting/ai/ai-search#enable-ai-search-in-workspace, "Wait for background job to generate embeddings for existing pages (You can monitor via logs if DEBUG_MODE: true env is set)" .

The error comes from here which looks for the page_embeddings table.

Web Terminal -> Postgres button -> Enter -> "\dt" (lists the tables). Do you see page_embeddings there?

[joseph]

@teiluj In the Web terminal -> postgres , you can do CREATE EXTENSION vector; This creates pgvector extension on the database. You can verify with \dx . Not sure what you have to do in docmost after you create the extension though. Maybe there is some button to create the tables again? Maybe try restarting the app.

db17f43a5953ed499cbe9ebaa84c652f85=> \dx
                                    List of installed extensions
   Name   | Version |   Schema   |                            Description                            
----------+---------+------------+-------------------------------------------------------------------
 pg_trgm  | 1.6     | public     | text similarity measurement and index searching based on trigrams
 plpgsql  | 1.0     | pg_catalog | PL/pgSQL procedural language
 unaccent | 1.1     | public     | text search dictionary that removes accents
 vector   | 0.8.2   | public     | vector data type and ivfflat and hnsw access methods
(4 rows)

[Teiluj]

Hi @joseph Thanks for this.
I can confirm that vector is now enabled.
Docmost is still complaining when I activate the option, but I see no "page_embeddings" tables at the moment so I will wait for a potential background creation and report.

Thanks again,