|
|
| Line 98: |
Line 98: |
| REINDEX DATABASE immich; | | REINDEX DATABASE immich; |
| </syntaxhighlight> | | </syntaxhighlight> |
|
| |
| ==== Upgrading pgvecto.rs ====
| |
| If you still run into issues after restarting postgresql and immich-server services, some additional postgresql database changes might be necessary to [https://web.archive.org/web/20240910231531/https://docs.pgvecto.rs/admin/upgrading.html#upgrading upgrade pgvecto.rs table]:
| |
|
| |
| Run <code>sudo -u postgres psql</code> and execute consecutively:<syntaxhighlight lang="sql" line="1">
| |
| CREATE EXTENSION IF NOT EXISTS unaccent;
| |
| CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
| |
| CREATE EXTENSION IF NOT EXISTS vectors;
| |
| CREATE EXTENSION IF NOT EXISTS cube;
| |
| CREATE EXTENSION IF NOT EXISTS earthdistance;
| |
| CREATE EXTENSION IF NOT EXISTS pg_trgm;
| |
| ALTER EXTENSION vectors UPDATE;
| |
| SELECT pgvectors_upgrade();
| |
| </syntaxhighlight>Finally, restart postgresql and immich: <code>systemctl restart postgresql && systemctl restart immich-server</code>
| |
|
| |
|
| === Immich server too old on NixOS stable === | | === Immich server too old on NixOS stable === |