Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 58B76B5DC13 for ; Wed, 14 Sep 2011 12:48:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 55444-10 for ; Wed, 14 Sep 2011 15:48:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from polaris.pinpointresearch.com (cerberus.pinpointresearch.com [66.7.238.130]) by mail.postgresql.org (Postfix) with ESMTP id 13A69B5DBD6 for ; Wed, 14 Sep 2011 12:48:08 -0300 (ADT) Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 755DCE00EC84; Wed, 14 Sep 2011 08:48:07 -0700 (PDT) Message-ID: <4E70CCB7.5080506@pinpointresearch.com> Date: Wed, 14 Sep 2011 08:48:07 -0700 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.21) Gecko/20110831 Lightning/1.0b2 Thunderbird/3.1.13 MIME-Version: 1.0 To: devrim@gunduz.org CC: Tom Lane , "pgsql-admin@postgresql.org Admin" Subject: Re: pg_upgrade difficulties References: <4E6FE821.5050403@pinpointresearch.com> <16242.1315960267@sss.pgh.pa.us> In-Reply-To: <16242.1315960267@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201109/100 X-Sequence-Number: 38337 On 09/13/2011 05:31 PM, Tom Lane wrote: > Steve Crawford writes: >> waiting for server to start....../usr/pgsql-9.1/bin/pg_ctl: symbol >> lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping >> There were problems executing "/usr/pgsql-9.1/bin/pg_ctl" -w -l >> "upgrade.log" -D "/var/lib/pgsql/9.1/data" -o "-p 5432 -b" start>> >> "upgrade.log" 2>&1 > This looks like your pg_ctl executable is mistakenly getting linked to a > pre-9.1 version of libpq.so. Don't know enough about the file layout in > the current PGDG RPMs to speculate as to why. > > regards, tom lane > Devrim, any thoughts? Cheers, Steve