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

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

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

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 sessio