Skip site navigation (1) Skip section navigation (2)

Re: pg_dump: Error message from server: ERROR: compressed data is corrupt

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Roman Chervotkin <roman(dot)chervotkin(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump: Error message from server: ERROR: compressed data is corrupt
Date: 2007-05-30 21:23:27
Message-ID: 20070530212327.GQ7128@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
Roman Chervotkin escribió:
> Hi list.
> 
> Do usual pg_dump today and have got an error.
> 
> ---------------------
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  compressed data is corrupt
> pg_dump: The command was: COPY public.candidates (id, name, surname,
> mid_name, compensation, created, birthday, updated, creator_id, updater_id,
> home_region_id, home_city, home_street, other_languages, home_region_other,
> edu_conformity, sex, deleted, resume_text, resume_text_index, mark, kids,
> driving_license, marital_status, software_knowledge, business_contacts,
> type_writing_rus, type_writing_lat, desired_duties, desired_other,
> updater_name, citizenship, compensation_currency, folder_id, plus,
> random_cat, temp_reg, "temp") TO stdout;
> ----------------------
> 
> I had 8.2.0 on Solaris 10 (SunOS server3 5.10 Generic_125101-05 ),
> pg_data_dir on zfs mirrored pool. I've checked status of pool and got:

Apparently ZFS betrayed you, and the data it recovered is not as good as
it seems to think.  If it were recovered correctly you wouldn't be
getting this error.

-- 
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"No es bueno caminar con un hombre muerto"

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2007-05-30 21:55:15
Subject: Re: Fwd: Out of Memory on Reindex
Previous:From: Andrew SullivanDate: 2007-05-30 21:18:33
Subject: Re: High Avaliable in the PostgreSQL.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group