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" ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
