Thread: 9.1.4: pg_restore: couldn't uncompress data?
This one is concerning. Trying to restore a backup from one system to another, and got this: pg_restore: restoring data for table "userid" pg_restore: restoring data for table "values" pg_restore: [compress_io] could not uncompress data: (null) pg_restore: *** aborted because of error [lrosenman@bpsandbox-db2 ~]$ ls -l db* -rw-rw-r-- 1 lrosenman blueprint 10838183690 Jul 23 17:58 db.backup.2012_07_21T062258 [lrosenman@bpsandbox-db2 ~]$ The file is the same size on both systems, and was transferred with scp. Any ideas why I would see this? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
On 07/24/2012 09:50 PM, Larry Rosenman wrote: > This one is concerning. Trying to restore a backup from one system to > another, and got this: > > pg_restore: restoring data for table "userid" > pg_restore: restoring data for table "values" > pg_restore: [compress_io] could not uncompress data: (null) > pg_restore: *** aborted because of error > [lrosenman@bpsandbox-db2 ~]$ ls -l db* > -rw-rw-r-- 1 lrosenman blueprint 10838183690 Jul 23 17:58 > db.backup.2012_07_21T062258 > [lrosenman@bpsandbox-db2 ~]$ > > The file is the same size on both systems, and was transferred with scp. > > Any ideas why I would see this? I just noticed you never saw any response to this. Did you eventually find a resolution? If not, verify the checksum on the file with md5sum on both sides. It'd also help if you'd mention the operating system(s) / distro(s), Pg version(s), etc involved. -- Craig Ringer
On Mon, July 30, 2012 9:14 pm, Craig Ringer wrote: > On 07/24/2012 09:50 PM, Larry Rosenman wrote: >> This one is concerning. Trying to restore a backup from one system to >> another, and got this: >> >> pg_restore: restoring data for table "userid" >> pg_restore: restoring data for table "values" >> pg_restore: [compress_io] could not uncompress data: (null) >> pg_restore: *** aborted because of error >> [lrosenman@bpsandbox-db2 ~]$ ls -l db* >> -rw-rw-r-- 1 lrosenman blueprint 10838183690 Jul 23 17:58 >> db.backup.2012_07_21T062258 >> [lrosenman@bpsandbox-db2 ~]$ >> >> The file is the same size on both systems, and was transferred with scp. >> >> Any ideas why I would see this? > I just noticed you never saw any response to this. > > Did you eventually find a resolution? If not, verify the checksum on the > file with md5sum on both sides. It'd also help if you'd mention the > operating system(s) / distro(s), Pg version(s), etc involved. > > -- > Craig Ringer > Didn't resolve it for this file. RHEL 5.4(IIRC), 64-bit, 9.1.4. I haven't had an issue with others. I'll check the sums. thanks! -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893