i’m still having issues I’m afraid. I do have a password in my local inventory/host_vars/{{ domain }}/passwords/postgres.psk and it does pass through to both POSTGRES_PASSWORD and PICTRS__SERVER__API_KEY in docker - compose.yml on the server.

docker compose logs show:

lemmy-1  | Error: LemmyError { message: Unknown("Error connecting to database"), inner: Error connecting to database
lemmy-1  | 
lemmy-1  | Caused by:
lemmy-1  |     connection to server at "postgres" (172.18.0.2), port 5432 failed: Connection refused
lemmy-1  |     	Is the server running on that host and accepting TCP/IP connections?
lemmy-1  |     , context: SpanTrace [] }
lemmy-1  | Lemmy v0.19.8
lemmy-1  | Error: LemmyError { message: Unknown("Error connecting to database"), inner: Error connecting to database
lemmy-1  | 
lemmy-1  | Caused by:
lemmy-1  |     connection to server at "postgres" (172.18.0.2), port 5432 failed: Connection refused
lemmy-1  |     	Is the server running on that host and accepting TCP/IP connections?
lemmy-1  |     , context: SpanTrace [] }
lemmy-1  | Lemmy v0.19.8
lemmy-1  | Error: LemmyError { message: Unknown("Error connecting to database"), inner: Error connecting to database
lemmy-1  | 
lemmy-1  | Caused by:
lemmy-1  |     connection to server at "postgres" (172.18.0.2), port 5432 failed: Connection refused
lemmy-1  |     	Is the server running on that host and accepting TCP/IP connections?
lemmy-1  |     , context: SpanTrace [] }
lemmy-1  | Lemmy v0.19.8
lemmy-1  | Error: LemmyError { message: Unknown("Error connecting to database"), inner: Error connecting to database
lemmy-1  | 
lemmy-1  | Caused by:
lemmy-1  |     connection to server at "postgres" (172.18.0.2), port 5432 failed: Connection refused
lemmy-1  |     	Is the server running on that host and accepting TCP/IP connections?
lemmy-1  |     , context: SpanTrace [] }
lemmy-1  | Lemmy v0.19.8
lemmy-1  | Error: LemmyError { message: Unknown("Error connecting to database"), inner: Error connecting to database
lemmy-1  | 
lemmy-1  | Caused by:
lemmy-1  |     connection to server at "postgres" (172.18.0.2), port 5432 failed: Connection refused
lemmy-1  |     	Is the server running on that host and accepting TCP/IP connections?
lemmy-1  |     , context: SpanTrace [] }
lemmy-1  | Lemmy v0.19.8
lemmy-1  | Federation enabled, host is dullsters.net
lemmy-1  | Starting HTTP server at 0.0.0.0:8536