Re: Handling glibc v2.28 breaking changes

2022-04-25 Thread Laurenz Albe
On Sun, 2022-04-24 at 23:31 +0800, Pradeep Chhetri wrote: > I am sure this has been discussed multiple times in the past but I would like > to initiate > this discussion again. I have 3 nodes cluster of Postgres v9.6. They all are > currently > running on Debian 9 (with glibc v2.24) and need to u

Re: Handling glibc v2.28 breaking changes

2022-04-25 Thread Nick Cleaton
On Mon, 25 Apr 2022 at 12:45, Laurenz Albe wrote: > > You could consider upgrade in several steps: > > - pg_upgrade to v14 on the current operating system > - use replication, than switchover to move to a current operating system > on a different > machine > - REINDEX CONCURRENTLY all indexes o

Re: Handling glibc v2.28 breaking changes

2022-04-25 Thread Pradeep Chhetri
Thank you Laurenz and Nick. That sounds like a good plan to me. Best Regards, Pradeep On Mon, Apr 25, 2022 at 9:44 PM Nick Cleaton wrote: > On Mon, 25 Apr 2022 at 12:45, Laurenz Albe > wrote: > >> >> You could consider upgrade in several steps: >> >> - pg_upgrade to v14 on the current operatin

Re: LwLocks contention

2022-04-25 Thread Michael Lewis
On Thu, Apr 21, 2022 at 6:17 AM Chris Bisnett wrote: > We're working to update our application so that we can > take advantage of the pruning. Are you also using native partitioning? > No partitioned tables at all, but we do have 1800 tables and some very complex functions, some trigger insanity

Re: LwLocks contention

2022-04-25 Thread Robert Treat
On Mon, Apr 25, 2022 at 10:33 AM Michael Lewis wrote: > > On Thu, Apr 21, 2022 at 6:17 AM Chris Bisnett wrote: >> >> We're working to update our application so that we can >> take advantage of the pruning. Are you also using native partitioning? > > > No partitioned tables at all, but we do have

Re: Problems with installation on Mac OS

2022-04-25 Thread José María Terry Jiménez
Hello Yes, i had this Execute the command it says and JDBC got installed without any problem. Don't remember if location shown was wrong, but you can install it if search for the package. El 23/4/22 a las 17:15, Daria Lesyk escribió: Hello, I'm trying to install PostgreSQL (the latest ve

Re: Problems with installation on Mac OS

2022-04-25 Thread Anthony DeBarros
Hi, El 23/4/22 a las 17:15, Daria Lesyk escribió: > > Hello, > I'm trying to install PostgreSQL (the latest version) on Mac but the > stackbuilder returns the following errors in the end of the installation of > PostgreSQL. > What I have to do to install that smoothly. > Thank you in advance for y