Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UpMR4-0003UB-Qt for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jun 2013 17:44:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UpMR4-0000ki-BC for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jun 2013 17:44:46 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UpMR3-0000kc-JZ for pgsql-admin@postgresql.org; Wed, 19 Jun 2013 17:44:45 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UpMR1-0004pc-7h for pgsql-admin@postgresql.org; Wed, 19 Jun 2013 17:44:44 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1UpMR0-0008V9-4v; Wed, 19 Jun 2013 13:44:42 -0400 Date: Wed, 19 Jun 2013 13:44:42 -0400 From: Bruce Momjian To: Marcos Cano Cc: pgsql-admin@postgresql.org Subject: Re: pg_upgrade issue Message-ID: <20130619174442.GC25261@momjian.us> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -0.5 (/) 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 On Wed, Jun 19, 2013 at 11:37:30AM -0600, Marcos Cano wrote: > ERROR: could not access file "$libdir/liblwgeom": No such file or directory > STATEMENT: LOAD '$libdir/liblwgeom' > command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/" > -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1 OK, so your database references '$libdir/liblwgeom', but the file does not exist in the 9.2.4 lib directory. Odds are it is some Postgres extension that you need to install in the new cluster. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin