2 months ago
Hi, everyone
I've been using Chatwoot through a template for about 4 months now.
However, I had never tried updating its version before.
Today, I tried doing it the same way I always do with n8n, by 'redeploying' the frontend.
But now it doesn’t work anymore — it keeps crashing repeatedly.
Has anyone else experienced this? Or does anyone know of an alternative way to recreate the environment without losing my data?
Error log:
ActiveRecord::StatementInvalid: PG::UndefinedFile: ERROR: could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory (ActiveRecord::StatementInvalid)
/app/db/migrate/20250104200055_create_captain_tables.rb:28:in `setup_vector_extension'
/app/db/migrate/20250104200055_create_captain_tables.rb:5:in `up'
/app/lib/tasks/db_enhancements.rake:26:in `block (3 levels) in <main>'
/app/lib/tasks/db_enhancements.rake:18:in `each'
/app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
Caused by:
PG::UndefinedFile: ERROR: could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory (PG::UndefinedFile)
/app/db/migrate/20250104200055_create_captain_tables.rb:28:in `setup_vector_extension'
/app/db/migrate/20250104200055_create_captain_tables.rb:5:in `up'
/app/lib/tasks/db_enhancements.rake:26:in `block (3 levels) in <main>'
/app/lib/tasks/db_enhancements.rake:18:in `each'
/app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
2 Replies
2 months ago
I got it working!
You just need to rename the Docker image to: pgvector/pgvector:pg14
In my case, I was using the 14-alpine
image.
I got it working!You just need to rename the Docker image to: pgvector/pgvector:pg14In my case, I was using the 14-alpine image.
2 months ago
Glad to see that this worked for you!
(Marking as resolved.)
Status changed to Awaiting User Response railway[bot] • about 2 months ago
Status changed to Solved angelo • about 2 months ago