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 Lane||Date: 2007-05-30 21:55:15|
|Subject: Re: Fwd: Out of Memory on Reindex |
|Previous:||From: Andrew Sullivan||Date: 2007-05-30 21:18:33|
|Subject: Re: High Avaliable in the PostgreSQL.|