Help, Postgres keeps on restarting

[githubbr]

Hi all, I am trying out Immich and so far it impresses.

I have an old iMac and an old PC and am still deciding where I will finally put Immich on. I installed Debian Bookworm on both machines and all is up and running.

I installed Immich on iMac first and it seems (as far as I can tell) everything works fine.

However, I can't seems to get it working on the PC, albeit it runs the same operating system. The Postgres keeps on restrating and the front end (web) won't load which I think because of issues with Postgres.

I don't change anything from the example docker-compose.yml and .env except for the Postgres password.

This is what I see on the web page:

Failed to get server config (500)
Stacktrace

de@http://localhost:2283/_app/immutable/chunks/fetch-client.B_ZOAMOm.js:1:2952
fe@http://localhost:2283/_app/immutable/chunks/fetch-client.B_ZOAMOm.js:1:2876

And this is the log for Postgres container. I hope someone can tell me how to fix and makes it work. Thank you in advance.

2024-06-30 22:45:22 The files belonging to this database system will be owned by user "postgres".
2024-06-30 22:45:22 This user must also own the server process.
2024-06-30 22:45:22 
2024-06-30 22:45:22 The database cluster will be initialized with locale "en_US.utf8".
2024-06-30 22:45:22 The default database encoding has accordingly been set to "UTF8".
2024-06-30 22:45:22 The default text search configuration will be set to "english".
2024-06-30 22:45:22 
2024-06-30 22:45:22 Data page checksums are enabled.
2024-06-30 22:45:22 
2024-06-30 22:45:22 fixing permissions on existing directory /var/lib/postgresql/data ... ok
2024-06-30 22:45:22 creating subdirectories ... ok
2024-06-30 22:45:22 selecting dynamic shared memory implementation ... posix
2024-06-30 22:45:22 selecting default max_connections ... 100
2024-06-30 22:45:22 selecting default shared_buffers ... 128MB
2024-06-30 22:45:22 selecting default time zone ... Etc/UTC
2024-06-30 22:45:22 creating configuration files ... ok
2024-06-30 22:45:23 running bootstrap script ... ok
2024-06-30 22:45:24 performing post-bootstrap initialization ... ok
2024-06-30 22:45:24 syncing data to disk ... ok
2024-06-30 22:45:24 
2024-06-30 22:45:24 
2024-06-30 22:45:24 Success. You can now start the database server using:
2024-06-30 22:45:24 
2024-06-30 22:45:24     pg_ctl -D /var/lib/postgresql/data -l logfile start
2024-06-30 22:45:24 
2024-06-30 22:45:25 waiting for server to start....2024-06-30 12:45:25.303 UTC [47] LOG:  redirecting log output to logging collector process
2024-06-30 22:45:25 2024-06-30 12:45:25.303 UTC [47] HINT:  Future log output will appear in directory "log".
2024-06-30 22:45:25  done
2024-06-30 22:45:25 server started
2024-06-30 22:45:26 CREATE DATABASE
2024-06-30 22:45:26 
2024-06-30 22:45:26 
2024-06-30 22:45:26 /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
2024-06-30 22:45:26 
2024-06-30 22:45:26 waiting for server to shut down.... done
2024-06-30 22:45:26 server stopped
2024-06-30 22:45:26 
2024-06-30 22:45:24 initdb: warning: enabling "trust" authentication for local connections
2024-06-30 22:45:24 You can change this by editing pg_hba.conf or using the option -A, or
2024-06-30 22:45:24 --auth-local and --auth-host, the next time you run initdb.
2024-06-30 22:45:26 PostgreSQL init process complete; ready for start up.
2024-06-30 22:45:26 
2024-06-30 22:47:26 
2024-06-30 22:47:26 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:47:26 
2024-06-30 22:47:49 
2024-06-30 22:47:49 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:47:49 
2024-06-30 22:48:07 
2024-06-30 22:45:26 2024-06-30 12:45:26.441 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:45:26 2024-06-30 12:45:26.441 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:47:27 2024-06-30 12:47:27.179 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:47:27 2024-06-30 12:47:27.179 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:47:49 2024-06-30 12:47:49.943 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:47:49 2024-06-30 12:47:49.943 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:48:07 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:48:07 
2024-06-30 22:48:25 
2024-06-30 22:48:25 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:48:25 
2024-06-30 22:48:36 
2024-06-30 22:48:36 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:48:36 
2024-06-30 22:48:45 
2024-06-30 22:48:45 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:48:45 
2024-06-30 22:48:51 
2024-06-30 22:48:51 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:48:51 
2024-06-30 22:48:58 
2024-06-30 22:48:58 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:48:58 
2024-06-30 22:49:06 
2024-06-30 22:49:06 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:49:06 
2024-06-30 22:49:17 
2024-06-30 22:49:17 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:49:17 
2024-06-30 22:49:34 
2024-06-30 22:49:34 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:49:34 
2024-06-30 22:50:06 
2024-06-30 22:50:06 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:50:06 
2024-06-30 22:51:03 
2024-06-30 22:51:03 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:51:03 
2024-06-30 22:52:09 
2024-06-30 22:52:09 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:52:09 
2024-06-30 22:53:17 
2024-06-30 22:53:17 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:53:17 
2024-06-30 22:54:24 
2024-06-30 22:54:24 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:54:24 
2024-06-30 22:55:31 
2024-06-30 22:55:31 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:55:31 
2024-06-30 22:56:37 
2024-06-30 22:56:37 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:56:37 
2024-06-30 22:57:44 
2024-06-30 22:57:44 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:57:44 
2024-06-30 22:58:51 
2024-06-30 22:58:51 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:58:51 
2024-06-30 22:59:58 
2024-06-30 22:59:58 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 22:59:58 
2024-06-30 23:01:06 
2024-06-30 23:01:06 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 23:01:06 
2024-06-30 23:02:13 
2024-06-30 23:02:13 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 23:02:13 
2024-06-30 23:03:20 
2024-06-30 23:03:20 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 23:03:20 
2024-06-30 23:04:28 
2024-06-30 23:04:28 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 23:04:28 
2024-06-30 23:05:36 
2024-06-30 23:05:36 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 23:05:36 
2024-06-30 23:06:43 postgres keeps 
2024-06-30 23:06:43 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-06-30 23:06:43 
2024-07-01 16:52:52 The files belonging to this database system will be owned by user "postgres".
2024-07-01 16:52:52 This user must also own the server process.
2024-07-01 16:52:52 
2024-07-01 16:52:52 The database cluster will be initialized with locale "en_US.utf8".
2024-07-01 16:52:52 The default database encoding has accordingly been set to "UTF8".
2024-07-01 16:52:52 The default text search configuration will be set to "english".
2024-07-01 16:52:52 
2024-07-01 16:52:52 Data page checksums are enabled.
2024-07-01 16:52:52 
2024-07-01 16:52:52 fixing permissions on existing directory /var/lib/postgresql/data ... ok
2024-07-01 16:52:52 creating subdirectories ... ok
2024-07-01 16:52:52 selecting dynamic shared memory implementation ... posix
2024-07-01 16:52:52 selecting default max_connections ... 100
2024-07-01 16:52:52 selecting default shared_buffers ... 128MB
2024-07-01 16:52:52 selecting default time zone ... Etc/UTC
2024-07-01 16:52:52 creating configuration files ... ok
2024-07-01 16:52:53 running bootstrap script ... ok
2024-07-01 16:52:54 performing post-bootstrap initialization ... ok
2024-07-01 16:52:54 syncing data to disk ... ok
2024-07-01 16:52:54 
2024-07-01 16:52:54 
2024-07-01 16:52:54 Success. You can now start the database server using:
2024-07-01 16:52:54 
2024-07-01 16:52:54     pg_ctl -D /var/lib/postgresql/data -l logfile start
2024-07-01 16:52:54 
2024-07-01 16:52:54 waiting for server to start....2024-07-01 06:52:54.880 postgres keeps UTC [48] LOG:  redirecting log output to logging collector process
2024-07-01 16:52:54 2024-07-01 06:52:54.880 UTC [48] HINT:  Future log output will appear in directory "log".
2024-07-01 16:52:54  done
2024-07-01 16:52:54 server started
2024-07-01 16:52:55 CREATE DATABASE
2024-07-01 16:52:55 
2024-07-01 16:52:55 
2024-07-01 16:52:55 /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
2024-07-01 16:52:55 
2024-07-01 16:52:55 waiting for server to shut down.... done
2024-07-01 16:52:55 server stopped
2024-07-01 16:52:55 
2024-07-01 16:52:55 PostgreSQL init process complete; ready for start up.
2024-07-01 16:52:55 
2024-07-01 16:54:06 
2024-07-01 16:54:06 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:54:06 
2024-07-01 16:54:14 
2024-07-01 16:54:14 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:54:14 
2024-07-01 16:54:25 
2024-07-01 16:54:25 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:54:25 
2024-07-01 16:54:34 
2024-07-01 16:54:34 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:54:34 
2024-07-01 16:54:44 
2024-07-01 16:54:44 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:54:44 
2024-07-01 16:54:55 
2024-07-01 16:54:55 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:54:55 
2024-07-01 16:55:07 
2024-07-01 16:55:07 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:55:07 
2024-07-01 16:55:25 
2024-07-01 16:55:25 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:55:25 
2024-06-30 22:48:07 2024-06-30 12:48:07.350 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:48:07 2024-06-30 12:48:07.350 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:48:26 2024-06-30 12:48:26.153 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:48:26 2024-06-30 12:48:26.153 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:48:36 2024-06-30 12:48:36.225 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:48:36 2024-06-30 12:48:36.225 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:48:45 2024-06-30 12:48:45.114 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:48:45 2024-06-30 12:48:45.114 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:48:51 2024-06-30 12:48:51.993 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:48:51 2024-06-30 12:48:51.993 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:48:58 2024-06-30 12:48:58.547 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:48:58 2024-06-30 12:48:58.547 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:49:06 2024-06-30 12:49:06.373 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:49:06 2024-06-30 12:49:06.373 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:49:17 2024-06-30 12:49:17.943 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:49:17 2024-06-30 12:49:17.943 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:49:34 2024-06-30 12:49:34.680 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:49:34 2024-06-30 12:49:34.680 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:50:06 2024-06-30 12:50:06.268 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:50:06 2024-06-30 12:50:06.268 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:51:03 2024-06-30 12:51:03.866 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:51:03 2024-06-30 12:51:03.866 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:52:09 2024-06-30 12:52:09.703 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:52:09 2024-06-30 12:52:09.703 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:53:17 2024-06-30 12:53:17.271 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:53:17 2024-06-30 12:53:17.271 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:54:24 2024-06-30 12:54:24.156 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:54:24 2024-06-30 12:54:24.156 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:55:31 2024-06-30 12:55:31.519 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:55:31 2024-06-30 12:55:31.519 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:56:38 2024-06-30 12:56:38.021 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:56:38 2024-06-30 12:56:38.021 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:57:45 2024-06-30 12:57:45.003 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:57:45 2024-06-30 12:57:45.003 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:58:51 2024-06-30 12:58:51.976 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:58:51 2024-06-30 12:58:51.976 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 22:59:58 2024-06-30 12:59:58.675 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 22:59:58 2024-06-30 12:59:58.675 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 23:01:06 2024-06-30 13:01:06.366 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 23:01:06 2024-06-30 13:01:06.366 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 23:02:13 2024-06-30 13:02:13.282 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 23:02:13 2024-06-30 13:02:13.282 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 23:03:20 2024-06-30 13:03:20.669 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 23:03:20 2024-06-30 13:03:20.669 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 23:04:28 2024-06-30 13:04:28.875 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 23:04:28 2024-06-30 13:04:28.875 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 23:05:36 2024-06-30 13:05:36.616 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 23:05:36 2024-06-30 13:05:36.616 UTC [1] HINT:  Future log output will appear in directory "log".
2024-06-30 23:06:43 2024-06-30 13:06:43.574 UTC [1] LOG:  redirecting log output to logging collector process
2024-06-30 23:06:43 2024-06-30 13:06:43.574 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:52:54 initdb: warning: enabling "trust" authentication for local connections
2024-07-01 16:52:54 You can change this by editing pg_hba.conf or using the option -A, or
2024-07-01 16:52:54 --auth-local and --auth-host, the next time you run initdb.
2024-07-01 16:52:55 2024-07-01 06:52:55.482 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:52:55 2024-07-01 06:52:55.482 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:54:06 2024-07-01 06:54:06.246 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:54:06 2024-07-01 06:54:06.246 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:54:14 2024-07-01 06:54:14.400 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:54:14 2024-07-01 06:54:14.400 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:54:25 2024-07-01 06:54:25.971 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:54:25 2024-07-01 06:54:25.971 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:54:35 2024-07-01 06:54:35.132 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:54:35 2024-07-01 06:54:35.132 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:54:44 2024-07-01 06:54:44.761 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:54:44 2024-07-01 06:54:44.761 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:54:55 2024-07-01 06:54:55.323 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:54:55 2024-07-01 06:54:55.323 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:55:07 2024-07-01 06:55:07.398 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:55:07 2024-07-01 06:55:07.398 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:55:25 2024-07-01 06:55:25.579 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:55:25 2024-07-01 06:55:25.579 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:55:57 2024-07-01 06:55:57.166 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:55:57 2024-07-01 06:55:57.166 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:56:55 2024-07-01 06:56:55.320 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:56:55 2024-07-01 06:56:55.320 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:58:03 2024-07-01 06:58:03.566 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:58:03 2024-07-01 06:58:03.566 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:59:10 2024-07-01 06:59:10.913 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 16:59:10 2024-07-01 06:59:10.913 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 17:00:15 2024-07-01 07:00:15.813 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 17:00:15 2024-07-01 07:00:15.813 UTC [1] HINT:  Future log output will appear in directory "log".
2024-07-01 16:55:57 
2024-07-01 16:55:57 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:55:57 
2024-07-01 16:56:55 
2024-07-01 16:56:55 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:56:55 
2024-07-01 16:58:03 
2024-07-01 16:58:03 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:58:03 
2024-07-01 16:59:10 
2024-07-01 16:59:10 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 16:59:10 
2024-07-01 17:00:15 
2024-07-01 17:00:15 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 17:00:15 
2024-07-01 17:01:21 
2024-07-01 17:01:21 PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-07-01 17:01:21 
2024-07-01 17:01:21 2024-07-01 07:01:21.415 UTC [1] LOG:  redirecting log output to logging collector process
2024-07-01 17:01:21 2024-07-01 07:01:21.415 UTC [1] HINT:  Future log output will appear in directory "log".

[githubbr]

bo0tzz at Discord helped me to resolve the issues. My system is probably too low specced :-( Managed to get it running by doing compose up one by one.