PostgreSQL Database directory appears to contain a database; Skipping initialization
2025-09-03 06:06:57.648 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-09-03 06:06:57.648 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-09-03 06:06:57.678 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-09-03 06:06:57.679 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-09-03 06:06:57.679 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-09-03 06:06:57.682 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-09-03 06:06:57.688 UTC [32] LOG:  database system was shut down at 2025-09-03 06:06:57 UTC
2025-09-03 06:06:57.698 UTC [1] LOG:  database system is ready to accept connections
2025-09-03 06:17:20.597 UTC [67] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-09-03 06:17:20.597 UTC [67] DETAIL:  Key ("ownerId", checksum)=(7cea2ddd-efec-4c81-9466-a5b0498592cd, \xfe97fae87648edcdb564c83cab2a0f5a3a839ea6) already exists.
2025-09-03 06:17:20.597 UTC [67] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-09-03 06:17:52.924 UTC [69] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-09-03 06:17:52.924 UTC [69] DETAIL:  Key ("ownerId", checksum)=(7cea2ddd-efec-4c81-9466-a5b0498592cd, \xf4fcf99b57eb3fb16c9cf70ee8a75c4b8ece8d91) already exists.
2025-09-03 06:17:52.924 UTC [69] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-09-03 06:17:56.883 UTC [65] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-09-03 06:17:56.883 UTC [65] DETAIL:  Key ("ownerId", checksum)=(7cea2ddd-efec-4c81-9466-a5b0498592cd, \xf80fe1a8fabceb82a246fe2053303cd3f545c549) already exists.
2025-09-03 06:17:56.883 UTC [65] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-09-03 06:17:57.421 UTC [61] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-09-03 06:17:57.421 UTC [61] DETAIL:  Key ("ownerId", checksum)=(7cea2ddd-efec-4c81-9466-a5b0498592cd, \x794af71fe5b7ef387713880249a52ab66b756bbe) already exists.
2025-09-03 06:17:57.421 UTC [61] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-09-03 06:17:59.064 UTC [58] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-09-03 06:17:59.064 UTC [58] DETAIL:  Key ("ownerId", checksum)=(7cea2ddd-efec-4c81-9466-a5b0498592cd, \x249fe5663a31b36b028fe4131e0498b05147acd3) already exists.
2025-09-03 06:17:59.064 UTC [58] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-09-03 06:19:00.863 UTC [58] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-09-03 06:19:00.863 UTC [58] DETAIL:  Key ("ownerId", checksum)=(7cea2ddd-efec-4c81-9466-a5b0498592cd, \xa27a1ffa8349048e350fe6bbadf1bc39d82637d3) already exists.
2025-09-03 06:19:00.863 UTC [58] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-09-03 06:22:50.433 UTC [68] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-09-03 06:22:50.433 UTC [68] DETAIL:  Key ("ownerId", checksum)=(7cea2ddd-efec-4c81-9466-a5b0498592cd, \x30dcab3d6c170797469a6607224690a95a19479c) already exists.
2025-09-03 06:22:50.433 UTC [68] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-09-03 18:06:19.447 UTC [1] LOG:  received fast shutdown request
2025-09-03 18:06:19.454 UTC [1] LOG:  aborting any active transactions
2025-09-03 18:06:19.462 UTC [1] LOG:  background worker "logical replication launcher" (PID 41) exited with exit code 1
2025-09-03 18:06:19.467 UTC [36] LOG:  shutting down
2025-09-03 18:06:19.565 UTC [1] LOG:  database system is shut down
Using SSD storage
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
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
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.
syncing data to disk ... ok
Success. You can now start the database server using:
    pg_ctl -D /var/lib/postgresql/data -l logfile start
2025-09-04 03:52:56.860 GMT [49] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-09-04 03:52:56.860 GMT [49] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
waiting for server to start....2025-09-04 03:52:56.893 GMT [54] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-09-04 03:52:56.893 GMT [54] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-09-04 03:52:57.012 UTC [54] 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-09-04 03:52:57.021 UTC [54] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-09-04 03:52:57.095 UTC [55] LOG:  database system was shut down at 2025-09-04 03:52:56 UTC
2025-09-04 03:52:57.109 UTC [54] LOG:  database system is ready to accept connections
 done
server started
2025-09-04 03:52:57.426 UTC [79] FATAL:  database "immich" does not exist
2025-09-04 03:52:57.480 UTC [82] FATAL:  database "immich" does not exist
CREATE DATABASE
/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
waiting for server to shut down...2025-09-04 03:52:57.701 UTC [54] LOG:  received fast shutdown request
.2025-09-04 03:52:57.703 UTC [54] LOG:  aborting any active transactions
2025-09-04 03:52:57.713 UTC [54] LOG:  background worker "logical replication launcher" (PID 62) exited with exit code 1
2025-09-04 03:52:57.716 UTC [57] LOG:  shutting down
2025-09-04 03:52:57.734 UTC [54] LOG:  database system is shut down
 done
server stopped
PostgreSQL init process complete; ready for start up.
2025-09-04 03:52:57.818 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-09-04 03:52:57.819 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-09-04 03:52:57.847 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-09-04 03:52:57.848 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-09-04 03:52:57.848 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-09-04 03:52:57.860 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-09-04 03:52:57.868 UTC [86] LOG:  database system was shut down at 2025-09-04 03:52:57 UTC
2025-09-04 03:52:57.881 UTC [1] LOG:  database system is ready to accept connections