2 years ago
Tried both standalone and bundled template with both services. The PostGis returns error:
Error: vectorsService.upsertVector - Error: QueryFailedError: extension "vector" is not availableLogs: 2024-06-01 04:56:24.591 UTC [123] ERROR: extension "vector" is not available
2024-06-01 04:56:24.591 UTC [123] DETAIL: Could not open extension control file "/usr/share/postgresql/16/extension/vector.control": No such file or directory.
2024-06-01 04:56:24.591 UTC [123] HINT: The extension must first be installed on the system where PostgreSQL is running.
2024-06-01 04:56:24.591 UTC [123] STATEMENT: CREATE EXTENSION IF NOT EXISTS vector;Tried to run command "CREATE EXTENSION vector;" in cli but says already exist. Log:2024-06-01 04:51:18.603 UTC [68] ERROR: extension "postgis" already exists
13 Replies
2 years ago
yes that is correct
2 years ago
can I open pgadmin within railway?
2 years ago
through pgAdmin, I can see two databases. The template sets a database called 'flowise' and in extensions 'postgis' is listed.
2 years ago
however, 'vector' is not and not in part of the extension list.
when I create 'vector' via cmd:
flowise=# CREATE EXTENSION vector;
ERROR: extension "vector" is not available
DETAIL: Could not open extension control file "/usr/share/postgresql/16/extension/vector.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
will need 'vector' to work with flowise, not sure how.
2 years ago
I would hope so, since its being used as a vector database. Also this package combination of flowise and Postgis was installed with below figures.
73 total projects
38 active projects
100% success on recent deploys
Are these accurate? if this combo doesnt work out of the box?
2 years ago
Yes they would be accurate, but the success rate is not a perfect metric by any means, it simply shows the percentage of deployments that haven't crashed in the last 25 template deploys.
2 years ago
the setup seems to need pgvector to be installed and calls made through pgvector. If true this template should include pgvector..
2 years ago
Wonder why the template creator used postgis then, either way it's easy enough to swap after you deploy.