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