Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kgWoZ-0008Os-Cx for pgsql-bugs@arkaria.postgresql.org; Sat, 21 Nov 2020 17:36:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kgWoY-0007Aq-A7 for pgsql-bugs@arkaria.postgresql.org; Sat, 21 Nov 2020 17:36:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kgWoY-0007Aj-3j for pgsql-bugs@lists.postgresql.org; Sat, 21 Nov 2020 17:36:46 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kgWoU-0003eB-VQ for pgsql-bugs@lists.postgresql.org; Sat, 21 Nov 2020 17:36:45 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 0ALHadOG1545764; Sat, 21 Nov 2020 12:36:39 -0500 From: Tom Lane To: rb9999999@gmail.com cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16737: error running compiled C program with connection to Postgres In-reply-to: <16737-71e193335e499c9a@postgresql.org> References: <16737-71e193335e499c9a@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Sat, 21 Nov 2020 09:14:49 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1545762.1605980199.1@sss.pgh.pa.us> Date: Sat, 21 Nov 2020 12:36:39 -0500 Message-ID: <1545763.1605980199@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PG Bug reporting form writes: > when running a compiled C program with connection attributes to postgres, I > now get the following error after upgrading to Big Sur: > dyld: Library not loaded: /usr/lib/libpq.5.dylib > Referenced from: /xxdir/program > Reason: image not found > Abort trap: 6 Complaining here won't help you with that. The Postgres project has no say in what Apple chooses to include in their operating system. Having said that, the version that Apple was shipping up through Catalina was pretty darn obsolete: $ ls -1 /usr/lib/libpq* /usr/lib/libpq.5.6.dylib /usr/lib/libpq.5.dylib /usr/lib/libpq.dylib libpq.5.6 would be from Postgres 9.3, which has been out of support for some time ... and it'd be a very good bet that this wasn't an end-of-life version anyway, meaning it's certainly missing security and other bug fixes. So personally I wouldn't use that anyway. The most obvious path forward is to use Homebrew or MacPorts to install Postgres, as well as anything else you need. (It looks like Apple culled a heck of a lot from /usr/lib in Big Sur, not only libpq.) regards, tom lane