Unable to init and run postgresql-12 on centos 8.2.2004

On Sun, Jun 21, 2020, 8:57 AM Vishal Agrawal <agrawal.vishal@gmail.com>
wrote:

Hello,

I'm trying to install postgresql 12 on CentOS 8.2 as following -

First I run docker container on the host -
# docker run --privileged -dit --name pgdg centos:8.2.2004 /sbin/init

Then inside the container, I run the commands given below -

# yum -y install glibc-langpack-en glibc-locale-source
# localedef -i en_US -f UTF-8 en_US.UTF-8

# dnf install
https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# dnf -qy module disable postgresql

# dnf install postgresql12-server

# /usr/pgsql-12/bin/postgresql-12-setup initdb

# systemctl enable postgresql-12

# systemctl start postgresql-12

Postgresql starts at this point...

However, when I try to stop it, it just hangs -

# systemctl stop postgresql-12 (hangs)

Can someone help how to resolve this?

Thanks,
Vishal

Looking at logs might help.

Regards,
Seenu.

Seenu, I don't see any journalctl entry other than the log that postmaster
has been killed. (Jun 21 14:52:30 f9cbc3b08e20 systemd[1]:
postgresql-12.service: Killing process 1096 (postmaster) with signal
SIGKILL.)
Any further suggestions on where to look ?

It does seem to work with systemd-239-18 (8.1.1911) but fails
with systemd-239-30 (In 8.2.2004 repo).

On Sun, Jun 21, 2020 at 6:05 AM Srinivasa T N <seenutn@gmail.com> wrote:

On 6/21/20 7:53 AM, Vishal Agrawal wrote:

Seenu, I don't see any journalctl entry other than the log that
postmaster has been killed. (Jun 21 14:52:30 f9cbc3b08e20 systemd[1]:
postgresql-12.service: Killing process 1096 (postmaster) with signal
SIGKILL.)
Any further suggestions on where to look ?

It does seem to work with systemd-239-18 (8.1.1911) but fails
with systemd-239-30 (In 8.2.2004 repo).

You might want to add report to this issue:

https://bugs.centos.org/view.php?id=17461

0017461: systemd-239-30 package prevents some units from stopping

"The postgresql unit installed in the postgresql:9.6 package on centos
8.2 fails to stop when using systemd-239-30 and running in an LXD
container. ..."

On Sun, Jun 21, 2020 at 6:05 AM Srinivasa T N <seenutn@gmail.com
<mailto:seenutn@gmail.com>> wrote:

On Sun, Jun 21, 2020, 8:57 AM Vishal Agrawal
<agrawal.vishal@gmail.com <mailto:agrawal.vishal@gmail.com>> wrote:

Hello,

I'm trying to install postgresql 12 on CentOS 8.2 as following -

First I run docker container on the host  -
# docker run --privileged -dit --name pgdg centos:8.2.2004
/sbin/init

Then inside the container, I run the commands given below -

# yum -y install glibc-langpack-en glibc-locale-source
# localedef -i en_US -f UTF-8 en_US.UTF-8

# dnf install
https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# dnf -qy module disable postgresql

# dnf install postgresql12-server

# /usr/pgsql-12/bin/postgresql-12-setup initdb

# systemctl enable postgresql-12

# systemctl start postgresql-12

Postgresql starts at this point...

However, when I try to stop it, it just hangs -

# systemctl stop postgresql-12 (hangs)

Can someone help how to resolve this?

Thanks,
Vishal

Looking at logs might help.

Regards,
Seenu.

--
Adrian Klaver
adrian.klaver@aklaver.com

On Sun, Jun 21, 2020, 8:23 PM Vishal Agrawal <agrawal.vishal@gmail.com>
wrote:

Seenu, I don't see any journalctl entry other than the log that postmaster
has been killed. (Jun 21 14:52:30 f9cbc3b08e20 systemd[1]:
postgresql-12.service: Killing process 1096 (postmaster) with signal
SIGKILL.)
Any further suggestions on where to look ?

Looks like problem with systemd but no harm in checking postgres log
files. I assume that you have already tried "journalctl -l".

It does seem to work with systemd-239-18 (8.1.1911) but fails
with systemd-239-30 (In 8.2.2004 repo).

Any problem reverting to older version of systemd?

Regards,
Seenu.