Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZuMvy-0005YP-Sd for pgsql-admin@arkaria.postgresql.org; Thu, 05 Nov 2015 15:58:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZuMvy-0007Zk-Ax for pgsql-admin@arkaria.postgresql.org; Thu, 05 Nov 2015 15:58:42 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZuMvx-0007Zd-Pi for pgsql-admin@postgresql.org; Thu, 05 Nov 2015 15:58:41 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZuMvl-0007HT-Ky for pgsql-admin@postgresql.org; Thu, 05 Nov 2015 15:58:40 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id tA5FwNf1007864; Thu, 5 Nov 2015 10:58:24 -0500 From: Tom Lane To: Artem Tomyuk cc: pgsql-admin@postgresql.org Subject: Re: pg_upgrade fails In-reply-to: References: Comments: In-reply-to Artem Tomyuk message dated "Thu, 05 Nov 2015 17:42:49 +0200" Date: Thu, 05 Nov 2015 10:58:23 -0500 Message-ID: <7863.1446739103@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Artem Tomyuk writes: > Trying to upgrade from 9.1 to 9.4 > Upgrade fails with error: > Could not load library "$libdir/dblink" > ERROR: could not load library "/usr/pgsql-9.4/lib/dblink.so": > /usr/pgsql-9.4/lib/dblink.so: undefined symbol: PQsetSingleRowMode dblink.so is apparently trying to link to the 9.1 version of libpq.so, which lacks some functions that exist in 9.4. You probably need to install the 9.4 libpq.so library first (it should work with 9.1 callers, unlike vice versa). regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin