Remove separate vector database

biigle / core

:large_blue_circle: Application core of BIIGLE

https://biigle.de

GNU General Public License v3.0

12 stars 16 forks source link

Remove separate vector database #720

Closed mzur closed 6 months ago

mzur commented 6 months ago

The default database is now used as vector database, too.

This partially undos #670.

References https://github.com/biigle/maia/pull/150

[x] Write a migration guide for the vector database (see here)
[x] Test the migration guide
[x] Update the biigle.de backup scripts https://github.com/biigle/biigle.de/pull/102
[x] Update the biigle.de database host setup instructions as well as the backup/restore instructions

mzur commented 6 months ago

Migration guide:

After step 4.1 of the updating instructions, do a vector database dump with the command:

docker exec -i $(docker compose ps -q vector_database) \
    pg_dump --insert --on-conflict-do-nothing --data-only -U biigle -d biigle > biigle_vector_db.sql

After step 6.1, run:

cat biigle_vector_db.sql | docker exec -i $(docker compose ps -q database) \
    psql -U biigle biigle -

Delete the vector_database Docker container and volume