2025-10-04 16:03:01.529 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-10-04 16:03:01.529 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-10-04 16:03:01.638 UTC [1] LOG:  starting PostgreSQL 14.19 (Debian 14.19-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
2025-10-04 16:03:01.639 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-10-04 16:03:01.639 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-10-04 16:03:01.672 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-10-04 16:03:01.735 UTC [32] LOG:  database system was interrupted; last known up at 2025-10-04 16:01:47 UTC
2025-10-04 16:03:03.022 UTC [32] LOG:  database system was not properly shut down; automatic recovery in progress
2025-10-04 16:03:03.052 UTC [32] LOG:  redo starts at 0/1951898
2025-10-04 16:03:03.052 UTC [32] LOG:  invalid record length at 0/1951A08: wanted 24, got 0
2025-10-04 16:03:03.052 UTC [32] LOG:  redo done at 0/19519D0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2025-10-04 16:03:03.293 UTC [1] LOG:  database system is ready to accept connections
2025-10-04 16:03:11.604 UTC [62] ERROR:  cannot drop the currently open database
2025-10-04 16:03:11.604 UTC [62] STATEMENT:  DROP DATABASE IF EXISTS immich;
2025-10-04 16:03:11.604 UTC [62] ERROR:  current user cannot be dropped
2025-10-04 16:03:11.604 UTC [62] STATEMENT:  DROP ROLE IF EXISTS postgres;
2025-10-04 16:03:11.604 UTC [62] ERROR:  role "postgres" already exists
2025-10-04 16:03:11.604 UTC [62] STATEMENT:  CREATE ROLE postgres;
2025-10-04 16:03:13.249 UTC [64] ERROR:  database "immich" already exists
2025-10-04 16:03:13.249 UTC [64] STATEMENT:  CREATE DATABASE immich WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.utf8';
2025-10-04 16:04:33.156 UTC [75] ERROR:  canceling autovacuum task
2025-10-04 16:04:33.156 UTC [75] CONTEXT:  while scanning block 1059 of relation "public.asset_face"
        automatic vacuum of table "immich.public.asset_face"
2025-10-04 16:07:08.859 UTC [66] ERROR:  insert or update on table "album_asset" violates foreign key constraint "album_asset_assetsId_fkey"
2025-10-04 16:07:08.859 UTC [66] DETAIL:  Key (assetsId)=(0236e570-c541-42c8-ad9c-c3f31c114962) is not present in table "asset".
2025-10-04 16:07:08.859 UTC [66] STATEMENT:  ALTER TABLE ONLY public.album_asset
            ADD CONSTRAINT "album_asset_assetsId_fkey" FOREIGN KEY ("assetsId") REFERENCES public.asset(id) ON UPDATE CASCADE ON DELETE CASCADE;
2025-10-04 16:07:09.116 UTC [66] ERROR:  insert or update on table "asset_exif" violates foreign key constraint "asset_exif_assetId_fkey"
2025-10-04 16:07:09.116 UTC [66] DETAIL:  Key (assetId)=(0236e570-c541-42c8-ad9c-c3f31c114962) is not present in table "asset".
2025-10-04 16:07:09.116 UTC [66] STATEMENT:  ALTER TABLE ONLY public.asset_exif
            ADD CONSTRAINT "asset_exif_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES public.asset(id) ON DELETE CASCADE;
2025-10-04 16:07:09.259 UTC [66] ERROR:  insert or update on table "asset_file" violates foreign key constraint "asset_file_assetId_fkey"
2025-10-04 16:07:09.259 UTC [66] DETAIL:  Key (assetId)=(2b7e2dd3-1af2-456b-b01d-42c64a93d868) is not present in table "asset".
2025-10-04 16:07:09.259 UTC [66] STATEMENT:  ALTER TABLE ONLY public.asset_file
            ADD CONSTRAINT "asset_file_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES public.asset(id) ON UPDATE CASCADE ON DELETE CASCADE;