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--