Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UTC9y-000774-5j for pgsql-admin@arkaria.postgresql.org; Fri, 19 Apr 2013 14:19:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UTC9x-0007GN-M5 for pgsql-admin@arkaria.postgresql.org; Fri, 19 Apr 2013 14:19:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UTC9x-0007GE-0n for pgsql-admin@postgresql.org; Fri, 19 Apr 2013 14:19:29 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UTC9s-00013y-Re for pgsql-admin@postgresql.org; Fri, 19 Apr 2013 14:19:28 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id r3JEJMd8015288; Fri, 19 Apr 2013 10:19:22 -0400 (EDT) From: Tom Lane To: chanh.tran@free.fr cc: pgsql-admin@postgresql.org Subject: Re: Pb migrating database from Postgres 8.1 to 8.4 In-reply-to: <1513898572.54354333.1366376303229.JavaMail.root@spooler8-g27.priv.proxad.net> References: <1513898572.54354333.1366376303229.JavaMail.root@spooler8-g27.priv.proxad.net> Comments: In-reply-to chanh.tran@free.fr message dated "Fri, 19 Apr 2013 14:58:23 +0200" Date: Fri, 19 Apr 2013 10:19:21 -0400 Message-ID: <15287.1366381161@sss.pgh.pa.us> X-Pg-Spam-Score: -2.6 (--) 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 chanh.tran@free.fr writes: > I'm facing pbs trying to migrate my current database from Postgres 8.1 to 8.4. > pg_restore: [archiver (db)] could not execute query: ERROR: could not find function "gtsvector_in" in file "/usr/lib64/pgsql/tsearch2.so" Looks like you're missing the shared library that underlies tsearch2. The other errors seem to be consequences of this one. 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