Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3R8A-0004ic-07 for pgsql-admin@arkaria.postgresql.org; Thu, 07 Feb 2013 13:03:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U3R88-0002Rs-Gh for pgsql-admin@arkaria.postgresql.org; Thu, 07 Feb 2013 13:03:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3R7q-0002Db-VO for pgsql-admin@postgresql.org; Thu, 07 Feb 2013 13:02:51 +0000 Received: from mail-lb0-f174.google.com ([209.85.217.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3R7o-000180-9o for pgsql-admin@postgresql.org; Thu, 07 Feb 2013 13:02:50 +0000 Received: by mail-lb0-f174.google.com with SMTP id l12so2058333lbo.5 for ; Thu, 07 Feb 2013 05:02:47 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=x-received:date:from:to:message-id:subject:x-mailer:mime-version :content-type:x-gm-message-state; bh=7CYJrgLDTxHx3DT/NtmfElEB5dOT5XNvBK3rL/wf81s=; b=LoXKP7vl49FhgIRkziTjZN6L47vPTb/GdzAvG6+Bq7nKug6PUPi3/dV7RAYCAv3FC5 pc6OBIE97h7l2IMAlQzMTosvOUdJgNrD4SOGkmtQOBzQ5Uf/Yp18yhunbrhJMV6O2PrK nw436599uqYR6GXqu/v/cyJTCllsGc25vbcmPm3W0r7W97bSeLxPF+vn+mGqmEKoz6xg VpNvzQuyDrFEPPnhvSj42ws6SI1DkU/G5p3onKLIgDYbVL8oe/+zbkeeo5GEcBho/g52 1ovk7vLf8C6LG24VC7jVRZ0V5pUhv3nyD7vmp4akRBW7koI4abaeczYMMWIPx56ROQ27 y7Ng== X-Received: by 10.152.109.210 with SMTP id hu18mr1261998lab.12.1360242167441; Thu, 07 Feb 2013 05:02:47 -0800 (PST) Received: from [192.168.160.136] ([91.236.111.210]) by mx.google.com with ESMTPS id e9sm8928155lbz.1.2013.02.07.05.02.45 (version=TLSv1 cipher=RC4-SHA bits=128/128); Thu, 07 Feb 2013 05:02:46 -0800 (PST) Date: Thu, 7 Feb 2013 17:02:44 +0400 From: Vasiliy I Ozerov To: pgsql-admin@postgresql.org Message-ID: Subject: Unexpected chunk size when doing dump X-Mailer: sparrow 1.6.4 (build 1176) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="5113a5f4_5577f8e1_12087" X-Gm-Message-State: ALoCoQkI9N8hSl05MB9lWVIL2LvgoniNwTzKTV0UdPd1k/SVUAnADJJOLowcWU53UBrgwYRzYUjY X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --5113a5f4_5577f8e1_12087 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Good day! I have an error, when doing database dump: psql -U postgres -p 56432 postgres > postgres.sql pg_dump: [archiver (db)] query failed: ERROR: unexpected chunk size 384 (expected 389) in final chunk 1 for toast value 11589 in pg_toast_2619 pg_dump: [archiver (db)] query was: SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid Postgresql version is 9.0. There was not any problems with hard drives. The same error I get, when I am trying to dump db at slave server (replic). Reindex doesn't help me :( What can I do with this error? Thank you! -- Vasiliy I Ozerov --5113a5f4_5577f8e1_12087 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Good day=21

I have an error, when doing dat= abase dump:

psql -U postgres -p 56432 postg= res > postgres.sql

pg=5Fdump: =5Barchiver (db= )=5D query failed: ERROR:  unexpected chunk size 384 (expected 389) = in final chunk 1 for toast value 11589 in pg=5Ftoast=5F2619
pg=5F= dump: =5Barchiver (db)=5D query was: SELECT description, classoid, objoid= , objsubid =46ROM pg=5Fcatalog.pg=5Fdescription ORDER BY classoid, objoid= , objsubid

Postgresql version is 9.0. There was = not any problems with hard drives. The same error I get, when I am trying= to dump db at slave server (replic).

Reindex doesn't help me :(
=

What can I do with this error=3F

=
Thank you=21
-- 
Vasiliy I Ozerov

--5113a5f4_5577f8e1_12087--