Immich: Difference between revisions

(2 intermediate revisions by 2 users not shown)

Line 44:

Following Immichs [https://immich.app/docs/administration/backup-and-restore/ backup docs] and [https://immich.app/docs/guides/template-backup-script backup script] an automated backup using [[Borg backup]] could look something like this:

{{File|3=services.borgbackup.jobs."Immich" = {

paths = ~~"/var/lib/~~immich";

paths = config.services.immich.mediaLocation;

repo = "<path-to-borg-repo>";

startAt = "Sat 04:00";

Line 70:

Jul 01 14:23:12 server2 immich[178592]: line: '477',

Jul 01 14:23:12 server2 immich[178592]: routine: 'CheckMyDatabase'

Jul 01 14:23:12 server2 immich[178592]: }</syntaxhighlight>To fix this, run <code>sudo -u immich psql -d immich</code> and execute these to commands:<syntaxhighlight lang="sql" line="1">

Jul 01 14:23:12 server2 immich[178592]: }</syntaxhighlight>To fix this, run <code>sudo -u immich psql -d immich</code> and execute these two commands:<syntaxhighlight lang="sql" line="1">

ALTER DATABASE immich REFRESH COLLATION VERSION;

REINDEX DATABASE immich;

Line 78:

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 ~~postgresql~~ psql</code> and execute consecutively:<syntaxhighlight lang="sql" line="1">

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";

@@ Line 44: / Line 44: @@
 Following Immichs [https://immich.app/docs/administration/backup-and-restore/ backup docs] and [https://immich.app/docs/guides/template-backup-script backup script] an automated backup using [[Borg backup]] could look something like this:
 {{File|3=services.borgbackup.jobs."Immich" = {
-   paths = "/var/lib/immich";
+   paths = config.services.immich.mediaLocation;
    repo = "<path-to-borg-repo>";
    startAt = "Sat 04:00";
@@ Line 70: / Line 70: @@
 Jul 01 14:23:12 server2 immich[178592]:   line: '477',
 Jul 01 14:23:12 server2 immich[178592]:   routine: 'CheckMyDatabase'
-Jul 01 14:23:12 server2 immich[178592]: }</syntaxhighlight>To fix this, run <code>sudo -u immich psql -d immich</code> and execute these to commands:<syntaxhighlight lang="sql" line="1">
+Jul 01 14:23:12 server2 immich[178592]: }</syntaxhighlight>To fix this, run <code>sudo -u immich psql -d immich</code> and execute these two commands:<syntaxhighlight lang="sql" line="1">
 ALTER DATABASE immich REFRESH COLLATION VERSION;
 REINDEX DATABASE immich;
@@ Line 78: / Line 78: @@
 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 postgresql psql</code> and execute consecutively:<syntaxhighlight lang="sql" line="1">
+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";