container restarted -> postgresql dead but pid file exists

Mariel Cherkassky <[email protected]> Sun, 12 Jan 2020 10:29:57 +0200
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CA+t6e1kX0jBeG2mdBa2ocLnK+xFLM+vE+pJ-RHVYi6V6_A-JBQ@mail.gmail.com>
--000000000000aa9d1e059bed2a3d
Content-Type: text/plain; charset="UTF-8"

Hey,
I have a container that runs centos image with a few changes and postgresql
installed on it.
Whenever I start my container or restart it, the postgresql(12) starts in
the following state :
postgresql dead but pid file exists

For example :

[root@my_container_id /]# service postgresql status
postgresql (pid  128) is running...
[root@ my_container_id /]# exit
exit
[root@docker-node]# docker restart my_container_id
my_container_id
[root@ docker-node ]#
[root@ docker-node ]#
[root@ docker-node ]# docker exec -it my_container_id /bin/bash
[root@my_container_id /]# service postgresql status
postgresql dead but pid file exists


It happens since I upgraded my postgresql to version 12.
Does anyone else suffer from the same issue ?

--000000000000aa9d1e059bed2a3d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"rtl"><div dir=3D"ltr">Hey,</div><div dir=3D"ltr">I have a conta=
iner that runs centos=C2=A0image with a few changes and postgresql installe=
d on it.</div><div dir=3D"ltr">Whenever I start my container or restart it,=
 the postgresql(12) starts in the following state :=C2=A0</div><div dir=3D"=
ltr">postgresql dead but pid file exists<br></div><div dir=3D"ltr"><br></di=
v><div dir=3D"ltr">For example :=C2=A0</div><div dir=3D"ltr"><br>[root@my_c=
ontainer_id /]# service postgresql status<br>postgresql (pid =C2=A0128) is =
running...<br>[root@

my_container_id=20

/]# exit<br>exit<br>[root@docker-node]# docker restart=20

my_container_id <br>

my_container_id=20

<br>[root@

docker-node

]#<br>[root@

docker-node

]#<br>[root@

docker-node

]# docker exec -it=20

my_container_id=20

/bin/bash<br>[root@my_container_id=20

 /]# service postgresql status<br>postgresql dead but pid file exists<br><b=
r></div><div dir=3D"ltr"><br></div><div dir=3D"ltr">It happens since I upgr=
aded my postgresql to version 12.</div><div dir=3D"ltr">Does anyone else su=
ffer from the same issue ?</div><div dir=3D"ltr"><br></div><div dir=3D"ltr"=
><br></div></div>

--000000000000aa9d1e059bed2a3d--