RE: Postgresql initialize error

2024-06-11 Thread Smith, Travis
Just be safe over sorry install openssl and openssl-dev packages. You may want to run updatedb, if you have the locate package installed just to double verify [cid:image001.jpg@01DABC13.84FC2AD0] Travis Smith VP Business Technology Circana From: nikhil kumar Sent: Tuesday, June 11, 2024 3:23

Re: Postgresql initialize error

2024-06-11 Thread nikhil kumar
As I check we have OpenSSL package in that server but that file is not visible On Wed, 12 Jun 2024 at 1:35 AM, nikhil kumar wrote: > Thanks for your support. I’ll check it > > On Wed, 12 Jun 2024 at 1:34 AM, Muhammad Salahuddin Manzoor < > salahuddi...@bitnine.net> wrote: > >> Greetings, >> >>

Re: Postgresql initialize error

2024-06-11 Thread nikhil kumar
Thanks for your support. I’ll check it On Wed, 12 Jun 2024 at 1:34 AM, Muhammad Salahuddin Manzoor < salahuddi...@bitnine.net> wrote: > Greetings, > > Check OpenSSL installed on your system > openssl version > > If not installed > sudo apt-get install openssl > > Find library > sudo find / -name

Re: Postgresql initialize error

2024-06-11 Thread Muhammad Salahuddin Manzoor
Greetings, Check OpenSSL installed on your system openssl version If not installed sudo apt-get install openssl Find library sudo find / -name libssl.so.1.1 Add in Library path export LD_LIBRARY_PATH=/path/to/libssl:$LD_LIBRARY_PATH *Salahuddin (살라후딘**)* On Wed, 12 Jun 2024 at 00:59, nikhil

Re: Postgresql initialize error

2024-06-11 Thread nikhil kumar
Error ; ./ initdbs error while loading shared libraries: libssl.so.1.1: cannot open shared object file: No such file or directory On Wed, 12 Jun 2024 at 1:28 AM, nikhil kumar wrote: > Hi Team, > > I'm installing postgresql 14 version by using Rpm. However i'm getting > error while execute the

Postgresql initialize error

2024-06-11 Thread nikhil kumar
Hi Team, I'm installing postgresql 14 version by using Rpm. However i'm getting error while execute the database initialzation. Please check below error message Error; Hi Team, I'm installing postgresql 14 version by using Rpm. However i'm getting error while execute the database initialzation.

Re: Distinct performance dropped by multiple times in v16

2024-06-11 Thread Andrei Lepikhov
On 6/10/24 13:59, Vitaliy Litovskiy wrote: ) tbl2 on tbl1.token = tbl2.token Observations: 1. query runs for 4-5 seconds on v16 and less than a second on v15 2. in v16 it also goes downs to less than a second if 2.1 distinct is removed 2.2 unnest is removed. it is not really needed for this pa