any documentation for migration from old PGVector to the new one?

[arezazadeh]

are there any documentaion for migrating from old PGVector to the new one? I have lots of user's data sitting in my database and i do not want to lose them. and there is no proper documentation that shows the migration process without losing data

[arezazadeh]

ok i figured it out, i had to build the db on a new machine with new pgvector to see the difference.

If you are facing the same issue follow below steps:

• What has changes:

  In langchain_pg_embedding they have removed the uuid field with uuid field type and replaced it with id with character varying for whatever reason.

• Solution

  1. Create another field id with char varying type,
  2. Copy your uuid fields values to id field ,
  3. change the primary key from uuid to id
  4. drop the uuid field.

also they have changed bunch of other stuff like arguments to PGVector class, be mindful of those as well.