Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id D8C3D1337B7E for ; Wed, 22 Dec 2010 02:45:10 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 53657-08 for ; Wed, 22 Dec 2010 06:45:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gunduz.org (ns1.gunduz.org [77.79.103.58]) by mail.postgresql.org (Postfix) with ESMTP id 2C4041337B6C for ; Wed, 22 Dec 2010 02:45:01 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.gunduz.org (Postfix) with ESMTP id EE056400394; Wed, 22 Dec 2010 08:50:21 +0200 (EET) X-Virus-Scanned: amavisd-new at mail.gunduz.org Received: from mail.gunduz.org ([127.0.0.1]) by localhost (mail.gunduz.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ZnNu3drzFftZ; Wed, 22 Dec 2010 08:50:21 +0200 (EET) Received: from [10.22.2.57] (unknown [95.0.200.34]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.gunduz.org (Postfix) with ESMTPSA id AA682400390; Wed, 22 Dec 2010 08:50:21 +0200 (EET) Subject: Re: Problems Upgrading from 8.2 to 9.0 From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= To: Adib Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg="pgp-sha1"; protocol="application/pgp-signature"; boundary="=-+QQj4k5d9zuhnWBrUELJ" Date: Wed, 22 Dec 2010 08:44:56 +0200 Message-ID: <1293000296.2291.2.camel@hp-laptop02.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 (2.30.3-1.fc13) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/155 X-Sequence-Number: 36384 --=-+QQj4k5d9zuhnWBrUELJ Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, 2010-12-21 at 22:39 -0800, Adib wrote: > ERROR: type "tsvector" is only a shell > ERROR: operator class "gin_tsvector_ops" does not exist for access > method > "gin=20 *IIRC*, you need to load contrib/tsearch2.sql to database *before* restoring your backup. Regards, --=20 Devrim G=C3=9CND=C3=9CZ PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz --=-+QQj4k5d9zuhnWBrUELJ Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEABECAAYFAk0RnmQACgkQtl86P3SPfQ4gNQCgtVLjLhg4T+BWVJMpZ7wgvVhn k1UAn3o1/0FNAcCzzXkIIvp9dltDGa5J =oicB -----END PGP SIGNATURE----- --=-+QQj4k5d9zuhnWBrUELJ--