Possible to add pgvector to a normal postgres instance?
andremaytorena
PROOP

7 months ago

i have a bunch of databases which I want to add the extension to, I know there's a template but having to migrate all of the data wouldn't be very easy

Solved$10 Bounty

7 Replies

andremaytorena
PROOP

7 months ago

N/A


7 months ago

While there is another way, I personally would still pgdump the database and pgrestore it to a new pgvector enabled Postgres service.


andremaytorena
PROOP

7 months ago

is the other way not any faster?


andremaytorena
PROOP

7 months ago

I just have like 6 databases I would need to migrate all constantly used all day so would need to find appropriate times to do the migrations


7 months ago

The other option is faster, but I have no idea how practical that is, given that I have only tried it with a dummy Postgres service and not one with actual data. The alternative way in question is to change the source from ghcr.io/railwayapp-templates/postgres-ssl:16 to pgvector/pgvector:pg16. However, as I have said, no guarantee for this to work at all. Always make sure to backup your database before any migration.


andremaytorena
PROOP

7 months ago

Hmm ok thank you


7 months ago

!s


Status changed to Solved uxuz 7 months ago


Loading...