Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 7E41A1337C6F
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 14 Oct 2010 06:51:07 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 76346-02-5
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 14 Oct 2010 09:50:58 +0000 (UTC)
X-Greylist: delayed 00:08:56.525027 by SQLgrey-1.7.6
Received: from work.netasq.com (mars.netasq.com [91.212.116.3])
	by mail.postgresql.org (Postfix) with ESMTP id 59EE31338178
	for <pgsql-admin@postgresql.org>; Thu, 14 Oct 2010 06:22:12 -0300 (ADT)
Received: from [10.1.32.1] (sebastienw.netasq.com [10.1.32.1])
	by work.netasq.com (Postfix) with ESMTPSA id 2B3F9740098;
	Thu, 14 Oct 2010 11:12:19 +0200 (CEST)
Message-ID: <4CB6C9A5.8070908@netasq.com>
Date: Thu, 14 Oct 2010 11:13:09 +0200
From: =?ISO-8859-1?Q?S=E9bastien_WACHTER?= <sebastien.wachter@netasq.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr;
	rv:1.9.2.9) Gecko/20100915 Lightning/1.0b2 Thunderbird/3.1.4
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
CC: nicolas treels <nicolas.treels@netasq.com>
Subject: error with pgdump
Content-Type: multipart/alternative;
	boundary="------------020508030104070106010300"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201010/117
X-Sequence-Number: 35858

This is a multi-part message in MIME format.
--------------020508030104070106010300
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  hi all
im new user with posgres , we use a sofware solution based on postgres 
sql to store database.
when i want dump database for backup

pg_dump -h localhost -b -Fc -U applicationdbuser application  -f fichier.dmp
after a few time i have this error

EERROR: *invalid* page *header* in block 10 of relation "pg_toast_16610"

have you an idea to fix it ?


i have try to reindex , when i search on google or forum i have see this 
solution  for same case

with command
reindex index pg_toast.pg_toast_16610;

but i have this error
relation "pg_toast.pg_toast_16610" d'ont exist

thanks a lot






--------------020508030104070106010300
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    hi all <br>
    im new user with posgres , we use a sofware solution based on
    postgres sql to store database.<br>
    when i want dump database for backup <br>
    <br>
    pg_dump -h localhost -b -Fc -U applicationdbuser application&nbsp; -f
    fichier.dmp<br>
    after a few time i have this error <br>
    <br>
    <span class="ul-threaded" style="margin: 0.5em 0pt 0pt -20px;"><span
        class="text-cell"><span>EERROR: <b class="highlight">invalid</b>
          page <b class="highlight">header</b> in block 10 of relation
          "pg_toast_16610"
          <br>
          <br>
          have you an idea to fix it ? <br>
          <br>
          <br>
          i have try to reindex , when i search on google or forum i
          have see this solution&nbsp; for same case <br>
          <br>
          with command <br>
          reindex index pg_toast.pg_toast_16610;<br>
          <br>
          but i have this error <br>
          relation "pg_toast.pg_toast_16610" d'ont exist <br>
          <br>
          thanks a lot <br>
          <br>
          <br>
          <br>
          <br>
          <br>
        </span></span></span>
  </body>
</html>

--------------020508030104070106010300--