pg_isready: FATAL: database "ContainerUser" does not exist

[mloskot]

Spawning this issue from #3 (comment)

PS> docker run  --rm satrapu/postgresql:15.1-windows
2023-08-08 08:20:54.126 GMT [1352] LOG:  starting PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit
2023-08-08 08:20:54.127 GMT [1352] LOG:  listening on IPv6 address "::", port 5432
2023-08-08 08:20:54.128 GMT [1352] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2023-08-08 08:20:54.334 GMT [1592] LOG:  database system was shut down at 2022-12-02 21:21:48 GMT
2023-08-08 08:20:54.396 GMT [1352] LOG:  database system is ready to accept connections
2023-08-08 08:20:58.878 GMT [1808] FATAL:  database "ContainerUser" does not exist
2023-08-08 08:21:04.039 GMT [1872] FATAL:  database "ContainerUser" does not exist
2023-08-08 08:21:09.194 GMT [1936] FATAL:  database "ContainerUser" does not exist
2023-08-08 08:21:14.353 GMT [1996] FATAL:  database "ContainerUser" does not exist
...

which can be reproduced manually in the running container:

It looks like pg_isready here needs an explicit -U or PGUSER environment variable exported

postgresql-docker-images/postgresql/Dockerfile.windows

Line 28 in 576efcb

HEALTHCHECK --interval=5s --timeout=60s CMD pg_isready