X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id A8D75924C1E for ; Sat, 24 May 2003 17:12:32 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 70855-09 for ; Sat, 24 May 2003 17:12:31 -0400 (EDT) Received: from europa.janwieck.net (h00045a2e4e7c.ne.client2.attbi.com [24.131.181.55]) by developer.postgresql.org (Postfix) with ESMTP id B7FFB924C18 for ; Sat, 24 May 2003 17:12:30 -0400 (EDT) Received: from Yahoo.com (linksys.janwieck.net [192.168.192.1]) (authenticated) by europa.janwieck.net (8.11.6/8.11.6) with ESMTP id h4OLCON04236; Sat, 24 May 2003 17:12:25 -0400 Message-ID: <3ECFE017.7060800@Yahoo.com> Date: Sat, 24 May 2003 17:11:51 -0400 From: Jan Wieck Organization: Unorganized User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Eric Anderson Vianet SAO Cc: pgsql-sql@postgresql.org Subject: Re: see toast table References: <001101c31fb8$ebdb30c0$0701a8c0@netterm> <3ECE195A.7060209@Yahoo.com> <004901c3212e$8919fda0$0701a8c0@netterm> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/479 X-Sequence-Number: 13644 Eric Anderson Vianet SAO wrote: > because the following error: > > ´missing chunk number 0 for toast value 32067496´ > > I get ir when I try ´vacuum -e -v -z -e´ or a simple pg_dump. > > I would like to know what is this value. And how could i fix it. You have probably a corrupted toast index on a table. Try to reindex it and if that doesn't help hunt down the damaged main row and update it's toasted value with something fresh (there have been enough discussions about it, you should find how to do that in the mailing list archives. These discussions will also point out that you probably have some bad memory and/or other non trustworthy piece of hardware including the tools you should use to identify the damage. Jan > > tnx. > > Eric Anderson Martins Miranda > Net Admin @ Via Net SAO > ----- Original Message ----- > From: "Jan Wieck" > To: "Eric Anderson Vianet SAO" > Cc: > Sent: Friday, May 23, 2003 9:51 AM > Subject: Re: [SQL] see toast table > > > >>Eric Anderson Vianet SAO wrote: >> >>>How coul i see a toast table. >>> >>>i can´t visualise it at pgadmin. >> >>I was wondering what you expect to see then? They are a technical >>implementation detail within the storage management. >> >> >>Jan >> >>-- >>#======================================================================# >># It's easier to get forgiveness for being wrong than for being right. # >># Let's break this rule - forgive me. # >>#================================================== JanWieck@Yahoo.com # > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #