a year ago
I deployed the pgvector PostgreSQL template (Docker: pgvector/pgvector:pg16) via this Railway template.
The service launches, but when I run:
CREATE EXTENSION IF NOT EXISTS pgvector;
I get:
ERROR: extension "pgvector" is not available
DETAIL: Could not open extension control file "/usr/share/postgresql/16/extension/pgvector.control"
I checked with:
SELECT * FROM pg_available_extensions WHERE name = 'vector';
→ No result.
Please confirm if the template is broken or if I need to do something extra.
3 Replies
a year ago
Hello,
The service you linked to this ticket is not a pgvector service, it is a standard stock Postgres service.
If you want pgvector, please deploy the pgvector template from the + Create -> Template menu.
Best,
Brody
Status changed to Awaiting User Response Railway • about 1 year ago
brody
Hello, The service you linked to this ticket is not a pgvector service, it is a standard stock Postgres service. If you want pgvector, please deploy the pgvector template from the `+ Create` \-> `Template` menu. Best, Brody
a year ago
I followed your instructions and deployed the pgvector template via the + New → Template path inside my project, and I still get the same error:
Could not open extension control file "/usr/share/postgresql/16/extension/pgvector.control"
Please confirm that your image has pgvector actually installed on disk.
Status changed to Awaiting Railway Response Railway • about 1 year ago
a year ago
Yes, the deployed database now does have pgvector installed.
Please see their docs going forward -
https://github.com/pgvector/pgvector?tab=readme-ov-file#getting-started
Status changed to Awaiting User Response Railway • about 1 year ago
Status changed to Solved brody • about 1 year ago