Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id C236DB5DC07 for ; Tue, 13 Sep 2011 21:31:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 55773-04 for ; Wed, 14 Sep 2011 00:31:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 7669EB5DBD6 for ; Tue, 13 Sep 2011 21:31:08 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p8E0V7cr016243; Tue, 13 Sep 2011 20:31:07 -0400 (EDT) To: Steve Crawford cc: "pgsql-admin@postgresql.org Admin" Subject: Re: pg_upgrade difficulties In-reply-to: <4E6FE821.5050403@pinpointresearch.com> References: <4E6FE821.5050403@pinpointresearch.com> Comments: In-reply-to Steve Crawford message dated "Tue, 13 Sep 2011 16:32:49 -0700" Date: Tue, 13 Sep 2011 20:31:07 -0400 Message-ID: <16242.1315960267@sss.pgh.pa.us> From: Tom Lane 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/90 X-Sequence-Number: 38327 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