Docker postgres container instability and password fail error

Peter

2/9/23, 10:16 AM

I'm running Docker 3.6.0 on a Mac. I only run one container, which is a postgres 9.6 instance. Over the last few months, I've noticed the stability of the postgres instance get worse and worse and eventually I just restart the container multiple times a day and then it keeps crashing later on.

If I stop Docker completely, then start it again, I run "container logs " (without even starting any container) and it very rapidly logs this line repeatedly:

FATAL:  password authentication failed for user "postgres"
DETAIL:  Password does not match for user "postgres".
    Connection matched pg_hba.conf line 95: "host all all all md5"

I've tried to stop any programs that would be making a connection to this database (that I know of) and yet I still keep seeing this logged in fast succession.

I'm not totally sure if this logging is related to my problem with stability. Ultimately, I would like for the postgres instance to not crash all the time.

Docker is running with port 5432 mapped from my Mac to the docker instance (same port).

If I look within the container at: "/var/lib/postgresql/data/pg_hba.conf", I see it ends with:

host all all all md5

107

0 + 0

postgresql

docker

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Docker postgres container instability and password fail error

TH: ข้อผิดพลาดความไม่เสถียรของคอนเทนเนอร์ Docker Postgres และรหัสผ่านล้มเหลว

RO: Eroare de instabilitate a containerului Docker Postgres și de eroare a parolei

RU: Нестабильность контейнера Docker postgres и ошибка ввода пароля

VI: Docker postgres container mất ổn định và lỗi mật khẩu

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.