Data page checksums are enabled.
fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
initdb: warning: enabling "trust" authentication for local connections
syncing data to disk ... ok
Success. You can now start the database server using:
    pg_ctl -D /var/lib/postgresql/data -l logfile start
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
2025-08-18 12:09:17.805 GMT [61] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-18 12:09:17.807 GMT [61] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
waiting for server to start....2025-08-18 12:09:17.886 GMT [66] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-18 12:09:17.887 GMT [66] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-18 12:09:18.044 UTC [66] LOG:  starting PostgreSQL 14.18 (Debian 14.18-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-08-18 12:09:18.063 UTC [66] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-08-18 12:09:18.090 UTC [67] LOG:  database system was shut down at 2025-08-18 12:09:13 UTC
2025-08-18 12:09:18.115 UTC [66] LOG:  database system is ready to accept connections
 done
server started
CREATE DATABASE
/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
2025-08-18 12:09:20.732 UTC [66] LOG:  received fast shutdown request
waiting for server to shut down....2025-08-18 12:09:20.758 UTC [66] LOG:  aborting any active transactions
2025-08-18 12:09:20.763 UTC [66] LOG:  background worker "logical replication launcher" (PID 74) exited with exit code 1
2025-08-18 12:09:20.772 UTC [69] LOG:  shutting down
2025-08-18 12:09:20.878 UTC [66] LOG:  database system is shut down
 done
server stopped
PostgreSQL init process complete; ready for start up.
2025-08-18 12:09:20.997 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-18 12:09:20.998 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-18 12:09:21.138 UTC [1] LOG:  starting PostgreSQL 14.18 (Debian 14.18-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-08-18 12:09:21.139 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-08-18 12:09:21.139 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-08-18 12:09:21.164 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-08-18 12:09:21.199 UTC [84] LOG:  database system was shut down at 2025-08-18 12:09:20 UTC
2025-08-18 12:09:21.250 UTC [1] LOG:  database system is ready to accept connections
2025-08-18 12:24:03.537 UTC [1] LOG:  received fast shutdown request
2025-08-18 12:24:03.542 UTC [1] LOG:  aborting any active transactions
2025-08-18 12:24:03.564 UTC [1] LOG:  background worker "logical replication launcher" (PID 93) exited with exit code 1
2025-08-18 12:24:03.565 UTC [88] LOG:  shutting down
2025-08-18 12:24:03.665 UTC [1] LOG:  database system is shut down
Using SSD storage
PostgreSQL Database directory appears to contain a database; Skipping initialization
2025-08-18 12:24:04.556 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-18 12:24:04.557 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-18 12:24:04.691 UTC [1] LOG:  starting PostgreSQL 14.18 (Debian 14.18-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-08-18 12:24:04.694 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-08-18 12:24:04.694 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-08-18 12:24:04.700 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-08-18 12:24:04.723 UTC [32] LOG:  database system was shut down at 2025-08-18 12:24:03 UTC
2025-08-18 12:24:04.761 UTC [1] LOG:  database system is ready to accept connections
2025-08-19 20:35:17.895 UTC [1] LOG:  received fast shutdown request
2025-08-19 20:35:17.903 UTC [1] LOG:  aborting any active transactions
2025-08-19 20:35:17.913 UTC [1] LOG:  background worker "logical replication launcher" (PID 41) exited with exit code 1
2025-08-19 20:35:17.919 UTC [36] LOG:  shutting down
2025-08-19 20:35:17.979 UTC [1] LOG:  database system is shut down
Using SSD storage
PostgreSQL Database directory appears to contain a database; Skipping initialization
2025-08-19 20:35:18.968 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-19 20:35:18.968 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-08-19 20:35:19.137 UTC [1] LOG:  starting PostgreSQL 14.18 (Debian 14.18-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-08-19 20:35:19.138 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-08-19 20:35:19.138 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-08-19 20:35:19.141 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-08-19 20:35:19.149 UTC [32] LOG:  database system was shut down at 2025-08-19 20:35:17 UTC
2025-08-19 20:35:19.168 UTC [1] LOG:  database system is ready to accept connections
2025-08-20 06:05:22.993 UTC [2789] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-08-20 06:05:22.993 UTC [2789] DETAIL:  Key ("ownerId", checksum)=(d35380fb-6faf-4ac1-9867-84553eb11c42, \xc075c599f3b6ebc8d44747857df60f5a9a1aad9c) already exists.
2025-08-20 06:05:22.993 UTC [2789] STATEMENT:  with "asset" as (update "asset" set "id" = $1, "checksum" = $2, "originalPath" = $3, "type" = $4, "originalFileName" = $5, "deviceAssetId" = $6, "deviceId" = $7, "fileCreatedAt" = $8, "fileModifiedAt" = $9, "localDateTime" = $10, "duration" = $11, "livePhotoVideoId" = $12, "sidecarPath" = $13 where "id" = $14::uuid returning *) select "asset".*, to_json("asset_exif") as "exifInfo", (select coalesce(json_agg(agg), '[]') from (select "asset_face".*, "person" as "person" from "asset_face" left join lateral (select "person".* from "person" where "asset_face"."personId" = "person"."id") as "person" on true where "asset_face"."assetId" = "asset"."id" and "asset_face"."deletedAt" is null) as agg) as "faces" from "asset" left join "asset_exif" on "asset"."id" = "asset_exif"."assetId"
2025-08-20 09:54:36.969 UTC [3877] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-08-20 09:54:36.969 UTC [3877] DETAIL:  Key ("ownerId", checksum)=(d35380fb-6faf-4ac1-9867-84553eb11c42, \xc075c599f3b6ebc8d44747857df60f5a9a1aad9c) already exists.
2025-08-20 09:54:36.969 UTC [3877] STATEMENT:  with "asset" as (update "asset" set "id" = $1, "checksum" = $2, "originalPath" = $3, "type" = $4, "originalFileName" = $5, "deviceAssetId" = $6, "deviceId" = $7, "fileCreatedAt" = $8, "fileModifiedAt" = $9, "localDateTime" = $10, "duration" = $11, "livePhotoVideoId" = $12, "sidecarPath" = $13 where "id" = $14::uuid returning *) select "asset".*, to_json("asset_exif") as "exifInfo", (select coalesce(json_agg(agg), '[]') from (select "asset_face".*, "person" as "person" from "asset_face" left join lateral (select "person".* from "person" where "asset_face"."personId" = "person"."id") as "person" on true where "asset_face"."assetId" = "asset"."id" and "asset_face"."deletedAt" is null) as agg) as "faces" from "asset" left join "asset_exif" on "asset"."id" = "asset_exif"."assetId"
2025-08-20 10:14:05.729 UTC [3995] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-08-20 10:14:05.729 UTC [3995] DETAIL:  Key ("ownerId", checksum)=(d35380fb-6faf-4ac1-9867-84553eb11c42, \x273744f48aba7980b12197daa5e08097e5a7aeb3) already exists.
2025-08-20 10:14:05.729 UTC [3995] STATEMENT:  with "asset" as (update "asset" set "id" = $1, "checksum" = $2, "originalPath" = $3, "type" = $4, "originalFileName" = $5, "deviceAssetId" = $6, "deviceId" = $7, "fileCreatedAt" = $8, "fileModifiedAt" = $9, "localDateTime" = $10, "duration" = $11, "livePhotoVideoId" = $12, "sidecarPath" = $13 where "id" = $14::uuid returning *) select "asset".*, to_json("asset_exif") as "exifInfo", (select coalesce(json_agg(agg), '[]') from (select "asset_face".*, "person" as "person" from "asset_face" left join lateral (select "person".* from "person" where "asset_face"."personId" = "person"."id") as "person" on true where "asset_face"."assetId" = "asset"."id" and "asset_face"."deletedAt" is null) as agg) as "faces" from "asset" left join "asset_exif" on "asset"."id" = "asset_exif"."assetId"
2025-08-20 10:14:09.676 UTC [4001] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-08-20 10:14:09.676 UTC [4001] DETAIL:  Key ("ownerId", checksum)=(d35380fb-6faf-4ac1-9867-84553eb11c42, \xc075c599f3b6ebc8d44747857df60f5a9a1aad9c) already exists.
2025-08-20 10:14:09.676 UTC [4001] STATEMENT:  with "asset" as (update "asset" set "id" = $1, "checksum" = $2, "originalPath" = $3, "type" = $4, "originalFileName" = $5, "deviceAssetId" = $6, "deviceId" = $7, "fileCreatedAt" = $8, "fileModifiedAt" = $9, "localDateTime" = $10, "duration" = $11, "livePhotoVideoId" = $12, "sidecarPath" = $13 where "id" = $14::uuid returning *) select "asset".*, to_json("asset_exif") as "exifInfo", (select coalesce(json_agg(agg), '[]') from (select "asset_face".*, "person" as "person" from "asset_face" left join lateral (select "person".* from "person" where "asset_face"."personId" = "person"."id") as "person" on true where "asset_face"."assetId" = "asset"."id" and "asset_face"."deletedAt" is null) as agg) as "faces" from "asset" left join "asset_exif" on "asset"."id" = "asset_exif"."assetId"