Add pgvector to existing db
Is there a way to add the
pgvector extension to an already existing postgres database hosted on railway?Solution:Jump to solution
there isnt, but you can dump the tables from your preexisting database, deploy the pgvector template and then restore the tables to the pgvector database
8 Replies
Project ID:
b6238b67-1449-4085-9111-5da192d6ede2Project ID:
b6238b67-1449-4085-9111-5da192d6ede2b6238b67-1449-4085-9111-5da192d6ede2
Solution
there isnt, but you can dump the tables from your preexisting database, deploy the pgvector template and then restore the tables to the pgvector database
hmm okay
thanks
no problem!
@Brody just to clarify, is there an easy way to dump the data with railway or should i just use the postgres CLI tools?
theres this https://railway.app/template/postgres-plugin-migration
but i have not tested it for this scenario, might be worth a shot, couldnt hurt anything