Recent Postgresql 9.4 alpine image doesn't create a postgres role.

[rija]

I have a CI job that instantiate postgreql using 9.4-alpine image. Job suddenly failed because database won't start.
Up until the failure, the image id used is 48d6bb3f0449. The new postgresql image used in the failed job has an id of 65a424ba5ff8.

The error the database throws at startup is:

ERROR:  role "postgres" does not exist

Same problem happens when I use the 9.4.19-alpine image.
I've resolved this issue by using the 9.4.18-alpine image.

So there seems to be something wrong with the current 9.4.19-alpine image.

[tianon]

See #497 and #493.

[rija]

Thank you, I get it.

We already use POSTGRES_USER and POSTGRES_PASSWORD but the SQL script we use to bootstrap the database server had references to "postgres" user.

Everything now works with 9.4.19-alpine and 9.4-alpine after replacing those references with the value of POSTGRES_USER.
Without the fix from #493, we wouldn't have spotted the discrepancies in our script.