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 851333A2011; Fri, 5 Nov 2004 15:21:22 +0000 (GMT) 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 46785-05; Fri, 5 Nov 2004 15:21:09 +0000 (GMT) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 5F7083A3CA3; Fri, 5 Nov 2004 15:21:12 +0000 (GMT) Received: by emo.org.tr (Postfix, from userid 41643) id 40E6B2FE26; Fri, 5 Nov 2004 17:21:10 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id 396C6112196; Fri, 5 Nov 2004 17:21:10 +0200 (EET) Date: Fri, 5 Nov 2004 17:21:06 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: Sally Sally Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] VACUUM failing ??!! In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=PLING_QUERY, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200411/41 X-Sequence-Number: 15426 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Fri, 5 Nov 2004, Sally Sally wrote: > After running for more than 24 hrs (I have a large db), vacuum failed with > this message: > ERROR: failed to re-find parent key in "pg_type_typname_nsp_index" > Has anybody encountered this before? AFAIR, you have to REINDEX pg_type to get rid of this error. Regards, - -- Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBi5pmtl86P3SPfQ4RAtUDAJ4jyT6MMU3b7R/C4xVm918QsSTmkQCfZdCw AQ6DWpdXhkhVM6jFKUQCQK0= =GH8N -----END PGP SIGNATURE-----