I am trying to deploy Postgres in Kubernetes. I need to add this line at the bottom of pg_hba.conf:

host all all all md5

to have Postgres accept connections on Kubernetes proxy address.

What is the correct way to do it in the Dockerfile I use to build the image I later use in the kubernetes yaml file?

I have seen this in other Dockerfile, one generating the Postgres docker image from scratch:

RUN echo "host all  all    0.0.0.0/0  md5" >> /var/lib/postgresql/data/pg_hba.conf

But the resulting file does not include that entry, probably because it is ovewritten buy Postgres when starts up. Any idea what I should do?

Thanks

Clarification: I really don't want the Dockerfile to create another pg_hba.conf in an alternate path and specify it when running the Kubernetes docker, but simply to create a custom one in the standard location for it, for example, in /var/lib/postgresql/data/pg_hba.conf