i can=B4t visualise it at pgadmin.<= /DIV>

tnx

Eric Anderson Martins Miranda
Net Admin= @ Via=20 Net SAO

------=_NextPart_000_000E_01C31F9F.C6468F80-- From ch@rodos.fzk.de Fri May 23 09:39:55 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id B7EC0925FCD for ; Fri, 23 May 2003 05:39:55 -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 84189-08 for ; Fri, 23 May 2003 05:39:23 -0400 (EDT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by developer.postgresql.org (Postfix) with SMTP id C8DF99260BA for ; Fri, 23 May 2003 03:25:54 -0400 (EDT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Fri May 23 09:26:40 2003 +0200 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id JAA18680; Fri, 23 May 2003 09:25:40 +0200 (METDST) Message-ID: <3ECDCCF4.C0776589@rodos.fzk.de> Date: Fri, 23 May 2003 09:25:40 +0200 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Cc: eric@vianet-express.com.br Subject: Re: see toast table Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/455 X-Sequence-Number: 13620 > > How could i see a toast table. > > i can't visualise it at pgadmin. > RTFM. Read The Fine Manual. Especially: $PGSQLD/doc/html/catalog-pg-class.html $PGSQLD/doc/html/monitoring-stats.html $PGSQLD/doc/html/page.html Regards, Christoph From JanWieck@Yahoo.com Fri May 23 13:59:31 2003 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 3667A9258FA for ; Fri, 23 May 2003 09:59:31 -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 87312-08 for ; Fri, 23 May 2003 09:59:21 -0400 (EDT) Received: from europa.janwieck.net (h00045a2e4e7c.ne.client2.attbi.com [24.131.181.55]) by developer.postgresql.org (Postfix) with ESMTP id AD17992350E for ; Fri, 23 May 2003 08:52:17 -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 h4NCqBa01454; Fri, 23 May 2003 08:52:11 -0400 Message-ID: <3ECE195A.7060209@Yahoo.com> Date: Fri, 23 May 2003 08:51:38 -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> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/468 X-Sequence-Number: 13633 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 # From eric@vianet-express.com.br Fri May 23 14:17:29 2003 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 E94C59254E9 for ; Fri, 23 May 2003 10:17:29 -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 01878-02 for ; Fri, 23 May 2003 10:17:13 -0400 (EDT) Received: from vianet-express.com.br (unknown [200.161.16.186]) by developer.postgresql.org (Postfix) with ESMTP id 6049E925ACA for ; Fri, 23 May 2003 09:13:56 -0400 (EDT) Received: from netterm ([192.168.1.7]) by vianet-express.com.br (8.11.4/8.11.4) with SMTP id h4ND78S07520; Fri, 23 May 2003 10:07:08 -0300 Message-ID: <004901c3212e$8919fda0$0701a8c0@netterm> From: "Eric Anderson Vianet SAO" To: "Jan Wieck" Cc: References: <001101c31fb8$ebdb30c0$0701a8c0@netterm> <3ECE195A.7060209@Yahoo.com> Subject: Re: see toast table Date: Fri, 23 May 2003 10:23:44 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/469 X-Sequence-Number: 13634 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. 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 # From JanWieck@Yahoo.com Sat May 24 21:12:32 2003 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 #