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
7 Replies
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.
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.
7 months ago
!s
Status changed to Solved uxuz • 7 months ago