X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8C70B5287E for ; Mon, 27 Jun 2005 15:10:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65901-10 for ; Mon, 27 Jun 2005 18:10:26 +0000 (GMT) Received: from omr5.netsolmail.com (omr5.netsolmail.com [216.168.230.142]) by svr1.postgresql.org (Postfix) with ESMTP id 5A39752833 for ; Mon, 27 Jun 2005 15:10:25 -0300 (ADT) Received: from ms9.netsolmail.com (IDENT:mirapoint@[216.168.230.183]) by omr5.netsolmail.com (8.12.10/8.12.10) with ESMTP id j5RIAPqp021121 for ; Mon, 27 Jun 2005 14:10:25 -0400 (EDT) Received: from [192.168.2.2] ([200.122.159.195]) by ms9.netsolmail.com (Mirapoint Messaging Server MOS 3.2.2-GA) with ESMTP id DNC04049; Mon, 27 Jun 2005 14:10:22 -0400 (EDT) Subject: restore errors after 8.01 - 8.03 upgrade From: Werner Bohl Reply-To: WernerBohl@infutor.com To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: IDS de Costa Rica S.A. Date: Mon, 27 Jun 2005 12:14:34 -0600 Message-Id: <1119896074.30152.5.camel@sirio> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/236 X-Sequence-Number: 17991 Hi all! Have a problem when restoring from an upgraded (from 8.01) 8.03 database. On restore many tsearch2 functions aren't restored. Platform is Fedora Core 3 on x86. I remember seeing somewhere that a script must be run to upgrade system catalogs. Where is this script? TIA, -- Werner Bohl IDS de Costa Rica S.A.