Postgres Pro
Downloads
Home   >   mailing lists

Thread: Unable to init and run postgresql-12 on centos 8.2.2004

Unable to init and run postgresql-12 on centos 8.2.2004

From
Vishal Agrawal
Date:
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 -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

Re: Unable to init and run postgresql-12 on centos 8.2.2004

From
Srinivasa T N
Date:


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

Re: Unable to init and run postgresql-12 on centos 8.2.2004

From
Vishal Agrawal
Date:
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 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 -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.

Re: Unable to init and run postgresql-12 on centos 8.2.2004

From
Adrian Klaver
Date:
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

Re: Unable to init and run postgresql-12 on centos 8.2.2004

From
Srinivasa T N
Date:


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.


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


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