Re: WHERE 'Something%' LIKE ANY (array_field)
Thank it is working in my senario -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
Unable to init and run postgresql-12 on centos 8.2.2004
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
Re: Unable to init and run postgresql-12 on centos 8.2.2004
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 wrote: > > > On Sun, Jun 21, 2020, 8:57 AM Vishal Agrawal > 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. > >>
Dropped User Session
Hello, Is there a view in database to find sessions PID of dropped user in database? Thanks, Vishal
Re: Dropped User Session
I dropped a connected user in database, cannot find pid in pg_stat_activity. I can query from dropped user session but how to find session in database without going into OS. On Fri, 30 Nov 2018 at 5:08 PM, Vishal Kohli wrote: > Hello, > > Is there a view in database to find sessions PID of dropped user in > database? > > Thanks, > Vishal > > >
